I agree on indexing, but also, a good idea here, is to use the
application scope, or the domain scope to cache this data. Unless this
data is unique to each user. You just build controls to build your
domain arrays, so that your apps have constant access to them, across
users.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Feb 25, 2008, at 7:07 AM, Stefan Gonick wrote:
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
[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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
