LOL, i found out what it was. You can specify 'columntypelist' in the queryNew function. Its optional, but not specifying any data type put a significant increase in load time.
Insteresting.....good to know. On Mon, 7 Feb 2005 21:21:33 -0700, Jay McEntire <[EMAIL PROTECTED]> wrote: > Try the 2 links again. > > I had forgotten that cfttrace doesn't work unless you have debug priveledges. > > Ive populated the execution times for the qoqs during runtime and used > cfflush to spit them out in realtime > > Here is the app running on 6.1 (same server) > http://eureka.ext.usu.edu/spider.cfm?q=61&c=test > > Here is the app running on 7 (same server) > http://testext.usu.edu/spider.cfm?q=61&c=test > > On Mon, 7 Feb 2005 21:37:16 -0600, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > I agree that it is hard to answer the question, just wanted to point > > out that I was noticing the differences in speed. > > > > On Tue, 8 Feb 2005 03:31:09 -0000, Paul Vernon > > <[EMAIL PROTECTED]> wrote: > > > > The second link for me did take a noticeably longer time to load than > > > > the > > > first. The first kind of came up almost immediately. > > > > > > Strange, I tested 2 or 3 times and it was about the same... I test now and > > > there is a marked difference.... My comments however still stand. Without > > > knowing how big the original data set is what the queries look like and > > > also > > > the not knowing exactly how the inner workings of QoQ function, it's a bit > > > of a tricky question to answer as to whether there are any ways to improve > > > the situation. > > > > > > Paul > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193534 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
