Several examples there. I should definitely be able to find something I can use. Thanks a BILLION!
-----Original Message----- From: Adrian Forbes - ITD [mailto:[EMAIL PROTECTED] Sent: Thursday, April 29, 2004 9:32 AM To: [EMAIL PROTECTED] Subject: RE: [ASP] Not repeating the query to the database with every page change The main solutions would be to maybe store the results as XML in the Session but the suitability of that depends on the size of the results. To be super-smart you could retrieve and store only a few hundred rows and let the user page through them and when it advances beyond your results you get the next set from the database. The way to get the results letting the database do all the work is to create a temp table in a stored proc as described here; http://www.aspfaq.com/show.asp?id=2120 <http://www.aspfaq.com/show.asp?id=2120> -----Original Message----- From: Duggan, Denise [mailto:[EMAIL PROTECTED] Sent: 29 April 2004 2:26 To: '[EMAIL PROTECTED]' Subject: RE: [ASP] Not repeating the query to the database with every page change It's an Oracle database that we don't have rights to. We do, however, have rights to several SQL Server databases. They're on different computers, though, AFAIK, if that adds to the complexity. -----Original Message----- From: Adrian Forbes - ITD [mailto:[EMAIL PROTECTED] Sent: Thursday, April 29, 2004 9:23 AM To: [EMAIL PROTECTED] Subject: RE: [ASP] Not repeating the query to the database with every page change What is the database? -----Original Message----- From: Duggan, Denise [mailto:[EMAIL PROTECTED] Sent: 29 April 2004 2:19 To: '[EMAIL PROTECTED]' Subject: [ASP] Not repeating the query to the database with every page change Hi all, Trying to figure out how to do something and can't, for the life of me, figure out the best way to do it. What we've got is this standard search page and a standard results page. The results page is designed to show 20 records of the returned dataset and has navigational buttons where the use can go forward to see the next 20, go to the end to see the last 20, go to the start to see the first 20, you know... the standard stuff. Well, the person that wrote it wrote it such that every time the page changes, the system repeats the query to the database and then shows records X through Y depending on what page they're on. This worked well enough when the database was relatively small but now it's becoming a problem in terms of performance what with it repeating the call to the database every time the page changes. I'm trying to figure out some way to accomplish the same thing but without having to re-execute the query every time the page changes. I've thought about doing some sort of temporary table in another database (I don't have write rights to the database from which the information is drawn, but could stick the temp table on some other database). I'm wondering if XML would help this situation. I'm wondering if I could do some form of a text file and stick it on the user's machine to use temporarily (even if it's just in memory) but I don't know if cookies are allowed and that would be too big for a cookie anyway. I'm stuck and just wondering what's the best practice to handle something like this? Thanks in advance for any assistance you can give. Denise [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511 <http://www.c1tracking.com/l.asp?cid=5511> < http://www.c1tracking.com/l.asp?cid=5511 <http://www.c1tracking.com/l.asp?cid=5511> > http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/17folB/TM <http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/17folB/TM> < http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/17folB/TM <http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/17folB/TM> > ---------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages <http://groups.yahoo.com/group/active-server-pages> < http://groups.yahoo.com/group/active-server-pages <http://groups.yahoo.com/group/active-server-pages> > --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages <http://groups.yahoo.com/group/active-server-pages> < http://groups.yahoo.com/group/active-server-pages <http://groups.yahoo.com/group/active-server-pages> > --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <http://groups.yahoo.com/group/active-server-pages/> < http://groups.yahoo.com/group/active-server-pages/ <http://groups.yahoo.com/group/active-server-pages/> > * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service < http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > . [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511 <http://www.c1tracking.com/l.asp?cid=5511> http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/17folB/TM <http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/17folB/TM> ---------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages <http://groups.yahoo.com/group/active-server-pages> --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages <http://groups.yahoo.com/group/active-server-pages> --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <http://groups.yahoo.com/group/active-server-pages/> * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511 http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/17folB/TM ---------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
