|
|
Rank: Member
Groups: Member
Joined: 10/25/2009
Posts: 26
|
I have isolate a eo:grid in one test page, if the grid display over 50.000 records, the first time work, but the second time no, I will get "page not found". Allow paging is true.
If I try the same page with a normal gridview no problem!!!
Is there some tips for display grid with large data ?
|
|
Rank: Administration
Groups: Administration
Joined: 5/27/2007
Posts: 24,194
|
Hi,
For that many records you should use Callback mode. Have you tried that yet?
Thanks
|
|
Rank: Member
Groups: Member
Joined: 10/25/2009
Posts: 26
|
Eheheh you are always very fast and in right!! ;)
Yes now work perfectly.
My rank is newbie and I'm for really a newbie!! :)
p.s. Now I will read some tips for display my grid more quicly (with large data), do you have some tips ?
I know that is not a problem of eo:grid, the server send many data with 50.000 records.
I retrieve the data with an ExecuteReader!!!
|
|
Rank: Administration
Groups: Administration
Joined: 5/27/2007
Posts: 24,194
|
Hi,
The key to get callback mode to work efficiently is that you should never retrieve more than one page of data. So for example even if you have 50000 rows, but if your page size is 50, your server should only return 50 rows to you, this means you should implement paging on SQL level.
Depending on your DB server, there are different ways to implement paging on SQL level. For example, SQL Server supports ROW_NUMBER function that can be used for paging. You can also use SELECT TOP as demonstrated in our Grid sample. In any case we are no SQL expert so if you run into any problems with that, you will need to find someone else to help you out. :)
Thanks
|
|