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://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/
