Ted,
You must start your investigation by turning on debug, and looking at that incrementing numbers in the [] at the start of each line. Each number is the output of @TIMER at the start of that action. What you are looking for is what action took a lot of time to complete. It may or may not be the ones you think. Once you've isolated which action(s) are taking up the bulk of the processing, you can consider options to speed up the page. Robert _____ From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Monday, February 25, 2008 10:06 AM To: [email protected] Subject: Witango-Talk: performance question 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 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <http://www.ogdengroup.com/> http://www.ogdengroup.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
