Hi Ted,
From your description it seems like you have an indexing issue. It
shouldn't take
so long to do those queries. You might want to look into coming up
with good indexes
to speed things up.
Stefan
At 10:05 AM 2/25/2008, you wrote:
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
=====================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
