One example that Mr. Forta gave at his presentation in Dallas was
something like a shopping site could query all of it's products
at the beginning of a user's session.
Then each page there after would just query the one products
query. Thus only hitting the database one time during that user's session.
He also mentioned querying two different databases, then joining
them, then being able to query against the newly joined query. Again,
increasing database server efficiency.
Also, mentioned joining a query with a verity search or something
like that. Too much information at once. :)
Robert
-----Original Message-----
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 1:23 PM
To: CF-Talk
Subject: RE: CF rules!!!
I heard from Ben, that a good use for querying a query would be to compare
data between two remote datasources with ease. If there was no query a
query function, what would be the alternative to perform the same
comparison? I couldn't think of any other valuable uses for querying a
query, it would be great if yall could tell me some good uses for them!
by the way, la la al a ala looh oee lalala la la :P
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 1:11 PM
To: CF-Talk
Subject: RE: CF rules!!!
> Your adulation of "Query a Query" requires comment. That functionality has
> been asked for as far back as version 2.0, to my knowledge. Not that it
> isn't a great idea, just nothing new.
OK, my testing on the Beta has increased some of my template runs (the ones
that use 2 or 3 datasources, some on different database types) has cut the
running times down from a couple of minutes to about 20 seconds...
It's not a new idea, but I love that it's there now...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
