Dov,
Great stuff! Gonna implement it..
Cheers,
Baz
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 9:14 AM
To: CF-Talk
Subject: RE: Big Gateways
OK, so if this is what the query looks like (but larger), its probably
pretty efficent
anuary 10, 2006 8:41 AM
To: CF-Talk
Subject: RE: Big Gateways
Dov,
You bring up a lot of good points.
Here is a trimmed down example of one of my queries in a method:
SELECT DISTINCT MedicationID,
Medication, MedicationC
, BrandNameID, BrandNameManufacturer, BrandName
FROM (long
to search the
keywords. But then I would duplicate 90% of the query...
Thoughts?
Baz
-Original Message-
From: Dov Katz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 6:39 AM
To: CF-Talk
Subject: Re: Big Gateways
I'd say there's one issue with your logic I
I'd say there's one issue with your logic If all you mean by conditional
processing is a bunch of extra IF's and CFSWITCH's etc, then the speed impact
of those compared to database queries should be negligible.
For example, if you have 10 different paths through your big cfc method, based
o
Hi,
I have a gateway CFC that returns queries for medications. Medications are
complex things that have many properties and require many tables to store
all the info. As well, there are hundreds of different ways to query the
meds.
My question is how do people break up their methods in these case
5 matches
Mail list logo