I propose that the hash can be done before the query is "unpacked" as you
call it. It would need to include the entire query though, not just the
where.
Let's say I use the following code:
<cfset query = myGateway.createQuery() />
<cfset query.getWhere().isEqual("foo", "bar", 1) />
I see this as having five pieces of information which make this information
unique: The name of the table being queried (the gateway's name by default)
and the information passed to isEqual and the equal operator itself.
So, if that data's stored in a structure I could look over the structure and
append everything together into a string such as "FooEqualsFooBar1" ...and
hash that (if need be, that could be expensive).
The resulting string could be used as a key in structure to uniquely
identify the actual query (rather than this, which is a pointer to the
query).
All that data being stored in the query object would be converted to a
"real" oo query just in time for the actual query execution (and only the
first time the query is executed).
Doug
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tom Chiverton
Sent: Monday, September 25, 2006 11:43 AM
To: [email protected]
Subject: Re: [Reactor for CF] duckies has been merged
On Monday 25 September 2006 16:14, Doug Hughes wrote:
> See where I'm headed?
Something as simple as a hash of the where clause ?
It'd be interesting to see if doing the hash check (which must
mean 'unpacking' the Where ?) is just as bad as running it straight off.
--
Tom Chiverton
Helping to paradigmatically enable second-generation bandwidth
****************************************************
This email is sent for and on behalf of Halliwells LLP.
Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at
St James's Court Brown Street Manchester M2 2JF. A list of members is
available for inspection at the registered office. Any reference to a
partner in relation to Halliwells LLP means a member of Halliwells LLP.
Regulated by the Law Society.
CONFIDENTIALITY
This email is intended only for the use of the addressee named above and may
be confidential or legally privileged. If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents. If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 8008.
For more information about Halliwells LLP visit www.halliwells.com.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
