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 |
|
notmyrealname
98 Posts |
 Posted - 2009-07-22 : 08:57:01
|
| Hi.I have a VB.Net application that displays data in various grids. One grid in particular displays the result of SQL query that could return well over 10000 records (maybe even 100000). I know the first question is why show 10000-100000 records. The reason is because this is a very generic query that allows the user to search the entire database for specified values in a specified field. The requested combination could potentially return this enormous resultset. We do not want to eliminate this flexibilty. In addition, the grid control has a lot of built in features for grouping and summarizing data. The only pressing issue that we are faced with right now is how long it takes to fill the grid for some of the larger searches (minutes).My question is:Is it possible to modify my query to return only what is visible in the grid? I know this technology exists but i am not very familiar with it. Especially reproducing it on my own.If anyone has any idea i would really appreciate the advice.Thanks. |
|
|
asafg
Starting Member
39 Posts |
Posted - 2009-07-22 : 09:17:19
|
| I think that you are in the wrong place:Others can better answer about the SQL-query-times which I believe are very fast.Your time problem can be found in two places:1. the data transfer time from the SQL-SERVER to the client or WEB-SERVER (etc.)2. Filling the grid component. there are several ways to access the database and this can affect the amount of data you need to load at a time from the DB.I don't fully understand the methods - so I let others help you with that on a C# or vb.net forum |
 |
|
|
|
|
|
Only query what is visible in grid