Also you can try open a connection to the DB sometime in the start of
the users interaction with you site. could be something in the
background and a very simple small query but that will assure a
connection is setup and available for reuse. I don't think you are
going to beat the ,et direct connection but you should be able to get
closer.
--
Dan Stein MSN
Digital Software Solutions
[email protected]
www.dss-db.com
On Oct 6, 2009, at 10:17 AM, Anthony Humphreys wrote:
If you were to turn on Wiango's Debug, the number as the far left
show the time taken. Where is the longest delay, and work to reduce
that.
If you don't have caching turned on, the act of having to load the
taf file will add a delay and increase the time.
Remove unnecessary actions before the one which returns your
results. Large TAF files with lots of IF/ELSEIF actions will become
slower for the latter actions.
Witango puts the DB connection into a "pool" for re-use. The first
use of a database connection is slower than subsequent uses of the
same datasource. How long Witango keeps datasource connections open
can be controlled. Witango does cache the results of commonly used
queries, every query is done fresh from the DBMS.
Witango has been accused of being slow when using its looping
featues, @FOR and @ROWS, especially on on large result sets
(arrays). Is there any way to re-write the output to avoid using the
@ROWS, ie using the array parameters of @VAR, ie APREFIX, ASUFFIX,
RPREFIX, RSUFFIX, CPREFIX, CSUFFIX
see http://humphreys.org/reference/Witango4.5_Help/meta/metata7a.htm
On 10/6/09, Ted Wolfley <[email protected]> wrote:
Hi,
We created a simple ajax autocomplete retrieving name and company
from a sql server 2005 table on another server. We compared 2
different options.
Both servers are Windows 2003 32-bit
Using Witango 5.5, the query request took 528ms.
Using ASP.Net, the query request took 34 ms
The sql statement is the same for both queries
Wondering if someone could give an explanation why there is so much
difference in speed and is there a way to speed up the Witango query.
Ted Wolfley
Lead Internet and Database Programmer
The Ogden Group of Rochester
phone: (585) 321 1060 x23
fax: (585) 321 0043
[email protected]
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
