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
