Hi,
I think you'll find that Alister is suggesting his SQL code is _faster_, not
_slower_, than using cfa_ContentObjectFind.
N.
>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.
