Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wackoyacky
Starting Member
25 Posts |
 Posted - 2008-08-04 : 22:20:35
|
| Hi guys,We currently have this C# winform that has a grid (infragistics) that loads upto thousands of data. Normally what is the optimal way of retrieving the data, is it to get everything on one go or get records by chunk let's say by 500 records?Applying a paging navigation is not an option, since they want all the records to be loaded on the grid since they're fond of using the infragistics group by & sorting options.Thanks,Enzo |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-08-05 : 05:43:59
|
| datareader is the fastest way to go. if you're using a sproc then i guess you can optimize the sproc.but loading 1000 rows of data back to the client is never fast._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
wackoyacky
Starting Member
25 Posts |
Posted - 2008-08-05 : 06:48:42
|
| hi spirit!Yup I know, the debate within our team was that just incase there are 1000 records, would it be wiser to have them in chunk of 500 (meaning there will be 2 seperate db calls) or to get the entire records in one go to db.I guess it all ends up to the user whether they still want to be able to do somethings while waiting for the entire data to load or are they willing to wait.Thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-08-05 : 07:15:14
|
| unless you have 2 network cards the 2 chunk will be slower._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
wackoyacky
Starting Member
25 Posts |
Posted - 2008-08-05 : 21:04:38
|
| oic, I'll take that into consideration. Thanks |
|
|
|
|
|
|
Optimal Way of Retrieving Thousands of Records