Best paging approach to be used

[Navin]

HI,
Guys
There has been a lot of Ways to use paging in asp

1>Recordset approach -where whole records are pulled at client side...
and then only the records which are needed are filtered..
and now that is not the approach good as we are pulling unnesscary all
the 10,000 say for dispalying 100 records...if pagesize is 100

2>i have seen is the Stored procedure approach where data is inserted
in temp table and then only the records needed are pulled out...
now again the approcah is not feasbile as if the data in the table is
huge
then inserting in temp table is going to bring Troubles...

so both the approcaches are bottlenecks...
so brillant guys..... which the best approcah to implement paging in
asp...
i have seen google paging seems to be runing very fast?

so tell me which the best approcah to implement paging in asp

regds,
Navin Mahindroo

[Aaron Bertrand - MVP]

> so tell me which the best approcah to implement paging in asp

What does "best" mean? Fastest? You can test that in your environment.
Too many other factors to get an easy, authoritative answer from a 3rd party
like us...

[Bullschmidt]

You may want to look into this idea:

What's after TOP? by graz - 8/31/2000
[url]http://www.sqlteam.com/item.asp?ItemID=566[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!