Hi Alister...
I could be how you're approaching your SQL... make sure you're not using
nested SELECTS or separate SQL statements, use equijoins!
Assuming your database's optimizer understands transitivity, you should be
able to join the objects and properties table according to the N-1 rule:
Say you want to find objects based on three searchable properties, you can
construct the following SQL statement:
SELECT o.objectid, o.label
FROM objects o, properties p1, properties p2, properties p3
WHERE o.objectid = p1.objectid
AND p1.objectid = p2.objectid
AND p2.objectid = p3.objectid
AND p1.propertyname = 'Amount'
AND p1.integerdata > 200
AND p2.propertyname = 'ProductName'
AND p2.chardata = 'Vegemite'
AND p3.propertyname = 'Manufacturer'
AND p3.chardata = 'Kraft'
-----Original Message-----
From: Alister Lilley
To: Spectra-Talk
Sent: 6/02/01 17:42
Subject: speed problems
I am using spectra 1.01 and I have been using cfa_contentobjectfind,
this custom tag takes the page load speed from 849 milliseconds to over
2200 milliseconds, if I use sql and talk directly with the database I
get speeds of 875 milliseconds.
Any suggestions of how to speed things up.
Alister
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
