The default delete handler calls mdindexdelete once for each object called.
Since mdindexdelete allows you pass in multiple objects, I'd simple remove
that call, and add the code yourself, like so: (pseudo-code)
<CFLOOP ...
<CFA_ContentObject Delete ...>
</CFLOOP>
<CFA_MDINDEXDELETE list=same list i used above>
Of course, don't forget to do the same for the TypeIndex as well.
=======================================================================
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Tony Brett [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 13, 2000 11:25 AM
> To: '[EMAIL PROTECTED]'
> Subject: CFA_METADATAINDEXDELETE
>
>
> Hi,
>
> I'm having BIG performance problems (I'm using Spectra 1.01)!
>
> I'm simply trying to delete some instances of one of my (Article) objects
> using cfa_ContentObjectDelete but it's taking forever!
>
> Switching on debug, I've tracked it down to a call to
> CFA_METADATAINDEXDELETE - it takes about 1.5 seconds for each
> object. Note:
> I also see this when I do the delete through the webtop. Pretty slow when
> you want to delete 100 articles!
>
> Any ideas?
>
> Tony
>
> P.S Object creation is also very time consuming and this seems to
> be down to
> the fact that we are indexing properties. When the idexing is removed, the
> object creation is much faster.
> ------------------------------------------------------------------
> ------------
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/sp
> ectra_talk or send a message to
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
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.