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 |
|
hemant_ec48
Starting Member
7 Posts |
 Posted - 2009-09-17 : 14:34:30
|
| Hi friends,I have to access very large database,let me say one table contain morethan 2,00,000 rows & i have to used inner join with the another 2-3 table with same records.Due to performance issue on aspx page......now i have implement custom paging for gridview.so on each & every page click it will bring that page records from database. means if page size is 20 records and if i click 2 means it will bring records from 21 to 40.Here i have to used SQL Server 2000. So I am using traditional way like just create one temporary table with identity and inserting all 1,00,000 records to that table & bring records from that temp table & after that i drop the table.After implementing this thing performance issue is increase at some level but not that much as we r expecting.Here i can't use rowindex of SQL 2005 also.Ao is there any other way of doing this task for SQL server 2000.Hemant Patel Contact me : 09726242864 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-09-17 : 15:51:19
|
| do a search along the lines "stored procedure + paging + sql server" and you will find tons of articles... there are several ways to do this...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
SQL Query performance