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 |
|
pamyral_279
Posting Yak Master
143 Posts |
 Posted - 2007-01-22 : 09:27:57
|
| I use Sql server 2000.I have implemented paging as guide in link :http://dotnetjunkies.com/Tutorial/975BE770-E5DC-4610-870B-A82BDB9B8845.dcikIs peformance good ? My database has 200000 records.I feel my web application quite slowly in loading.I suppose that 100 user simultaneously run in store above links.Mean that it create 100 temp table and load 100 * 200000 records.is it correct ?Please give me valueable suggestion about performance. Thank you very much. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-22 : 10:16:06
|
| Are you using SQL Server 2005?SELECT *FROM YourTableNameHereWHERE ROWNUMBER() OVER (ORDER BY ...) / @PageSize = @PageNumber + 1Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
How to increase peformance in paging ?