Should have read: Witango does NOT cache the results of commonly used queries, every query is done fresh from the DBMS.
On 10/6/09, Anthony Humphreys <[email protected]> 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
