Yeah, gotcha on cfquery. Just wasn't sure if there was something under the hood I didn't know about.
Well, the tag won't be used too often (not trying to reinvent the wheel) so it doesn't need to be an "enterprise" version but your suggestions are greatly appreciated. I'll look into these things. Thx... On 10/25/05, Barney Boisvert <[EMAIL PROTECTED]> wrote: > > 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:222208 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
