On Thu, 8 Feb 2001, ananthi wrote:
> Date: Thu, 08 Feb 2001 10:50:54 +0800
> From: ananthi <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: Spectra-Talk <[EMAIL PROTECTED]>
> Subject: How to improve the performance
>
> Hi all,
>
> I am having one doubt.
>
> I am having 200 objects of a particular type, and i want to find out some
> objects in that type which matches with some conditions.
> So what i am doing is ,
>
> 1. Get all the objects of that type by using the <cfa_contentobjectfind>
> 2. Loop through the list and get the properties of that object by using
> <cfa_contentobjectget> tag, and match the properities by using if condition.
You don't want to do this. It's better to do something like
<cfa_contentobjectgetmultiple
datasource="xxx"
typeid="xxx"
r_stObjects="st"
bactiveonly="no"
>
And then loop over the st variable. You also might want to add some
caching techniques here. It's not a good idea to retrieve 10,000 objects
from a database on each page hit.
--
Michiel Boland <[EMAIL PROTECTED]>
Digital Valley Internet Professionals
Plantsoen 17, Wageningen, The Netherlands
Phone: +31 317 465555, Fax: +31 317 460276
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
