Yup, QofQ has zero performance optimizations built-in. I haven't actually played with it in CFMX, so I don't know if anything has changed. However, I did notice that CFMX has Pointbase embedded in it. Planning on figuring out what I can do with that.
Further, I did a presentation on complex caching a while back that covered sorting issues. You can find the presentation at, http://www.bacfug.net/Code/Complex_Caching.zip. -Matt > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 29, 2002 8:11 AM > To: CF-Talk > Subject: RE: Custom Tag for Sorting > > > Well, I'm biased - heck, I liked QofQ in CF5, but I think > > you should check out the docs for QofQ in MX. If you have > > avoided it in the past, there is no reason not to now. > > > > For example, to me, the biggest problem was the inability > > to do a case insenstive search. That has been corrected. > > Here are some of the problems I've seen: > > 1. Shockingly bad performance - in some cases, taking nearly 20 > milliseconds > to retrieve one record based on a single unique integer field search from > a > set of ~150 records! You'd get better performance by searching the query > using ValueList and ListFind! > > 2. Data truncation - that's kind of a bummer. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
