The time to convert OO queries to sql. The time spent executing the query isn't as big of a deal (although it would be nice to be able to cache some of that data at some point).
Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Blackwell Sent: Monday, September 25, 2006 10:48 AM To: [email protected] Subject: RE: [Reactor for CF] duckies has been merged Doug, can you just clarify for me, are you trying to speed up the conversion from OO -> SQL Query, or the actual time taken to run the SQL Query against the DB? Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Moretti > Sent: 25 September 2006 15:14 > To: [email protected] > Subject: Re: [Reactor for CF] duckies has been merged > > > > > I also had an interesting idea on how to speed up oo > queries (at least after > > their first run). First off, any given query is unique. > That is to say > > "Select * from User" is always "Select * from User" and is > never "Select * > > from FooBar". So, given that, I could hash the data used > to create the > > query and use that as a unique identifier for that query. > This would allow > > me to cache the query for reuse. > > > If I'm not mistaken this is how CF caches queries. If you pass a > query of exactly the same statement and the query is cached then it > uses the data from memory rather than requerying the database. I > guess if you could some how turn on or off query caching through > reactor, then CF should handle this for you. Of course you then get > into the issue of how/when do you tell it to requery the database > because the data has changed. > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
