paging through a very large table? please help 
Author Message
 paging through a very large table? please help

I am running msql 6.5 sp4. IIS4 connecting to the sql via ADO 1.5c
using VBscript.

I have written a guestbook program.  Ihave two tables that split up
the information for each guestbook entery.  guestbook1 and guestbook2.
In each table I have a userid and indentity field called msgid.  When
I was using MSAccess I could use paging to move through data, but in
mssql it does not support the paging mechinizm.  On the guestbook I
have nav buttons.   First10  next 10 back 10 and last 10.  

I need a way to page through the data in sql and just pull a 10 row rs
from the server with out having to pull all the rows for that user and
then get the right info within my vbscript.  I am doing this now but
the cpu hit is to large.  I would like something I can do in a stored
procedure so it is much faster..

1. if I use the set rowcount guestbook1 10  how can I keep track of
where i am in the table when the user hits the next button really is
the question.

Please I have been struggling with this for awhile and need some
expert help.

Brad



Tue, 28 Nov 2000 03:00:00 GMT
 paging through a very large table? please help

I have a stored procedure - VB/VBScript solution that does this that I've
implemented for a couple clients.  It has some limitations, but if you're
interested in the details, send me an e-mail.

--
Bob Pfeiff
MCSD, MVP
Spectrum Technolgy Group, Inc.



Tue, 28 Nov 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. HELP! SQL Paging + ASP VERY LARGE DATABASE TABLE

2. help with very large tables please...

3. Large table update/vacuum PLEASE HELP!

4. BDE creating large tables, URGENT!!,please help

5. losing distributed pages in large tables?

6. SELECT page-by-page from large dataset?

7. Distributed pages and large tables

8. Distributed pages and large tables

9. COMBO BOX, PLEASE HELP, PLEASE HELP, PLEASE HELP!

10. Large image tables and jukebox opinions please

11. Lock file has grown too large - please help

12. Please help with large chars fields !


 
Powered by phpBB® Forum Software