Hi Ed,
I expect SQL searching of the properties table would be faster. cfa_cof does
a call to cfa_objecttypeget to determine which properties are searchable,
searches for the objects and then calls cfa_contentObjectGetMultiple to get
theobjects. Other issues like how fast your database engine can perform
self-joins and how big your properties table might be limiting factors but I
expect 2 database hits is going to perform better than 3 or 4 or however
many the custom tag makes.
Assuming this is a determination you are trying to make in a real situation,
you can of course turn on Show Processing TIme in CF Administrator to see
which is actually faster.
Mark
-----Original Message-----
From: Ed McLaughlin [mailto:[EMAIL PROTECTED]]
Sent: Monday, 7 May 2001 11:34
To: Spectra-Talk
Subject: RE: <cfa_ContentObjectFind> and SQL-Style Search
I think the question is: which is more *effecient*. It's not a how do you do
it question. The original question spells out two mutually exclusive
scenarios. Let me rephrase the question.
Given a case where you'd want to search for an object by two different
property criteria, which method would be more effecient (faster, with fewer
hits to the database): using a standard cfquery call against the properties
table to retrieve the objectids and then using cfa_contentobjectget to
retrieve object data; or using cfa_ContentObjectFind.
Any insights would be most appreciated.
Ed
>>-----Original Message-----
>>From: Raymond Camden [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, May 07, 2001 8:54 AM
>>To: Spectra-Talk
>>Subject: RE: <cfa_ContentObjectFind> and SQL-Style Search
>>
>>
>>Eh? As far as I know 1.5 supports this. You simply used the
>>propertiesCriteria="ALL" property.
>>
>>==============================================================
>>=========
>>Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
>>
>>Email : [EMAIL PROTECTED]
>>ICQ UIN : 3679482
>>
>>"My ally is the Force, and a powerful ally it is." - Yoda
>>
>>> -----Original Message-----
>>> From: Michael Collins [mailto:[EMAIL PROTECTED]]
>>> Sent: Friday, May 04, 2001 9:06 PM
>>> To: Spectra-Talk
>>> Subject: RE: <cfa_ContentObjectFind> and SQL-Style Search
>>>
>>>
>>> Zhiyuan,
>>>
>>> To do what you are asking you will need to do a Self Join using SQL.
>>> Cfa_cof does not support an "and" condition using 2 properties.
>>>
>>> Check out
>>http://www.allaire.com/Handlers/index.cfm?ID=16106&Method=Full
>>> for complete details.
>>>
>>> HTH
>>>
>>>
>>> -----Original Message-----
>>> From: Zhiyuan Ma [mailto:[EMAIL PROTECTED]]
>>> Sent: Friday, May 04, 2001 4:19 PM
>>> To: Spectra-Talk
>>> Subject: <cfa_ContentObjectFind> and SQL-Style Search
>>>
>>>
>>>
>>> To search content objects on a given content object type with two
>>> properties
>>> as searchable, one property is defined as chardata and
>>another property is
>>> defined as integerdata, which way is more efficiency - use
>>> <cfa_ContentObjectFind> or do a SQL-Style search such as
>><Select objectid
>>> from properties where chardata is 'XYZ' and integerdata=123>?
>>>
>>> Thanks,
>>>
>>> Zhiyuan
>>>
>>> ~.~.~.~.~.~.~.~.~.~.~.~.~.~.~
>>> SVMedia
>>> 940 South Avenue West
>>> Suite D
>>> Westfield, NJ 07090
>>>
>>> ph 908.789.4200
>>> fax 908.789.4266
>>> http://www.svmedia.com/
>>>
>>> Strategic Internet Business Solutions
>>>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
