We have a site that has over 10,000 objects in a type in Spectra 1.01.
The original code on this site used ContentObjectGetMultiple to get all
of the objects and then looped through the objects to select out several
hundred or less. The problem we had is that ContentObjectGetMultiple by
default returns at most 10,000 objects so we were missing objects. We
replaced the ContentObjectGetMultiple and loop with a SQL query (the
properties were Searchable) and reduced the response time from over 5
minutes to 20 or 30 seconds. Now granted we had a lot of objects in the
type and were only looking for a few of them, but this is something to
keep in mind with Spectra 1.01. Does anyone know if Spectra 1.5 has
fixed this problem?
Nancy
-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:57 AM
To: Spectra-Talk
Subject: RE: search and replace
Well, normally you don't want to write your own SQL. What you should do
is
use ContentObjectFind to get the obs you want, loop through the results,
and
then use contentObjectData to update the objects.
=======================================================================
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 23, 2001 8:45 AM
> To: Spectra-Talk
> Subject: search and replace
>
>
>
> Hello,
>
> I want to replace strings in spectra objects. Therefore I need a
> SELECT and
> UPDATE statement, but I don't know the database model. Can anyone tell
me
> table and field names, where I can find all relevant (text)
> object content?
>
> Thanks,
> Guido Franz
>
>
> Internet communications are not secure and therefore MERCK FINCK &
> CO does not accept legal responsibility for the contents of this
message.
> Any views or opinions presented are solely those of the author and do
> not necessarily represent those of MERCK FINCK & CO unless
> specifically stated.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
