Dear all
I am building an asp.net application wich collect data from an SQL server
database.
Those data in this database can be huge with the time.
Actually, I am retriving those data through store procedure return in a
dataset object which is bind to a data grid. so all queroes are executed on
the SQL server.
When the amount of data increase, does that technique is still suitable or
is there some other tips ?
regards
serge
NuTcAsE - 13 Jan 2006 21:01 GMT
As the amount of data increases, the server's performance goes down as
it has to render a large amount of data. The ideal way to deal with
this is to set the data grid's page size property and let the data grid
deal with retrieving only a subset amount of data from the database.
Sample of setting data grid to use pagination...
http://msdn.microsoft.com/asp.net/default.aspx?pull=/library/en-us/dnaspp/html/G
ridViewEx05.asp
Hope this helps...
NuTcAsE