Using contentObjectGetMultiple to retrieve all the objects
when you only want a few is not a good idea. In the same
way you would not retrieve all the records in a database
to just get some you were interested in, you should not
do this in Spectra. cfa_contentObjectFind OUGHT to be
a better choice. Note I said ought -- in 1.01 this tag is still
pretty inefficient and in many cases it too will retrieve all
the objects and look at them. It is a lot smarter in 1.5 and
runs faster when you have the properties you are "selecting"
on declared to be searchable. There is an even faster
version in the works which we will probably see in the
maintenance release I'm guessing. In the meantime, if
you are stuck in 1.01 using SQL queries agains the
properties table is your best bet to get good performance.
Rich
> 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.
