Large Table - approach?
Posted: Thu 02 May 2013 02:52
Using PGSQlDataSource for a table with 400,000 records. Using Paging with an asp.net GridView.
Works pretty well. Speed acceptable. Sorting/Paging work as expected.
Now I am working with a table with over 100 million rows. Using the same approach as above.
Operation times out. I haven't had time to put dbMonitor in the app, but will do tomorrow.
My question is, what is best approach for dealing with this many records? I only want to display 25/50 at a time with sorting/paging.
Thanks,
Rob
Works pretty well. Speed acceptable. Sorting/Paging work as expected.
Now I am working with a table with over 100 million rows. Using the same approach as above.
Operation times out. I haven't had time to put dbMonitor in the app, but will do tomorrow.
My question is, what is best approach for dealing with this many records? I only want to display 25/50 at a time with sorting/paging.
Thanks,
Rob