[Solved] Grid with a lot of records HELP

[Peny]

Hello everyone,

I want to create a grid where the user will be able to edit all values (In place editing).
I tried to use the example for Excel-like grid but I cannot adjust it to my needs.

My main problems is that the "select" stored procedure takes about 5s to fetch all the results.
To avoid that I would like to aplly some filters, and custom paging to my grid.
Now I am trying to use the example for Batch Update(http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/clienteditbatchupdates/defaultcs.aspx) .

I am quite confused about which approach I should use.
I like the second one more, but I am not sure If it is the best solution.

Could you suggest me what whould be the better for 10000-20000 records with filters and paging?
I would also like to ask you about the dropdown lists in the grid for the Batch Update example.
Below is the code for my Dropdownlist where DOCUMENT_PERSONS_LEGAL_USER_REL_ID is the value that i get from my main query.

<telerik:GridTemplateColumn UniqueName="LEGAL_USER" HeaderText="LEGAL_USER" SortExpression="LEGAL_USER" headerStyle-Width="8%">
                    <ItemTemplate>
                        <asp:Label ID="lblLEGAL_USER" runat="server" Text='<%# Eval("LEGAL_USER") %>' />
                        <asp:DropDownList ID="ddlLEGAL_USER" runat="server" DataTextField="LEGAL_USER_LASTNAME"
                            DataValueField="LEGAL_USER_ID" DataSourceID="SqlDataSource2" SelectedValue='<%# Bind("DOCUMENT_PERSONS_LEGAL_USER_REL_ID") %>'
                            Style="display: none" />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:CCSI %>"
        SelectCommand="SELECT DISTINCT [LEGAL_USER_ID]  , LEGAL_USER_LASTNAME FROM LEGAL_USERS" />

The problem is that when the grid loads, at the column LEGAL_USER I see the value of the dropdown list, but I want to see the Text for the selected value.
For example
LEGAL_USER = 1
LEGAL_USER_LASTNAME = Peny
DOCUMENT_PERSONS_LEGAL_USER_REL_ID = 1

Now I at the grid I see the value 1 but i want to see Peny.  How could I do that?

I would really appreciate your help.

Regards,
Peny

[Princy]

Hello Peny,

Check the following help documentation which explains on how to handle large sets of data and also the following articles section

"Handling Large Data Sets"

Client/server grid performance optimizations.
Top Performance

Thanks,
Princy.