CFQUERY is not a custom tag, it's a full blown CF tag, which is basically a cross between [primitive] CFOUTPUT and CFSAVECONTENT to get the SQL statement, and then a bunch of database interaction stuff. It also deals with CFQUERYPARAM, of course.
If you do go with something similar to what I outlined, you'll want to set up a RAM disk (check your OS docs) to minimize the filesystem usage. And you'll want to do heavy caching of the query results, because it's still going to be hella slow for CF to have to write/read/compile/execute every single query statement. cheers, barneyb On 10/25/05, John C. Bland II <[EMAIL PROTECTED]> wrote: > Hmm...seems like way too much but along those lines I'll try similar. > > No ideas on how cfquery does it? > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:222207 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
