Hi,
I have a website running on Windows 2003 using Witango server 5.5.003 pulling data from Sql Server 2000 on a Windows Storage Server 2003. In the taf, there is a group of about 8 database I/O that are used to fill small arrays (scope: request) for use in choice lists each time a page is called, The data will rarely change and never in the same session. The main function of the taf is to search the database and return the most recent 1000 results, if there are that many and putting the results into an user array, which works fine. The taf then display the array in results of 20 using the start and stop of the array loop. When going from one page to another, it takes about 6 seconds. Since the main data is already in an array, the only thing accessing the database is the 8 database I/Os. How much pagination speed would I pick up if I change the small database I/Os to run just once and use user arrays? Ted Wolfley Lead Internet and Database Programmer The Ogden Group of Rochester phone: 585.321.1060 x23 fax: 585.321.0043 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://www.ogdengroup.com <http://www.ogdengroup.com/> ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
