Looks like this is one of those rare times when you can't actually lever the performance increase from using the db engine instead, as you're dealing with data created in CF.
you'll might find that you get greater performance looping over the 18,000 records and using case or if statements in cfscript than you do using QofQ. Even in CFMX there are instances where this is so. I had one query with a similar recordset (built dynamically from lots of conditions in the app) and QofQ performance was unacceptable but looping was quite zippy and perfectly acceptable performance-wise. > -----Original Message----- > From: Mark Woods [mailto:[EMAIL PROTECTED] > Sent: 03 June 2003 10:40 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] query of query performance (CF5) > > > thanks for the responses, looks like I'll be re-writing some > caching code > then :( > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
