If you are just after verity optimising for the spectra verity
collections (sounds like you are) then try something like this. It will
optimise all of your spectra collections.
<cfregistry action="GETALL"
branch="HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Co
llections" name="q" type="Key">
<cfloop query="q">
<cflock name="cfindex_collection_#entry#" timeout="30">
<cfcollection action="OPTIMIZE" collection="#entry#">
</cflock>
</cfloop>
Cheers,
Aaron.
-----Original Message-----
From: Stephen Collins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 5 February 2002 11:16 AM
To: Spectra-Talk
Subject: Maintaining indexes
Finalising the fiddly bits of a big Spectra project and just wondering
if there's a way to programmatically optimise Spectra indexes. I've
done it in the past with scheduled tasks from the WebTop, but the
production servers for this project will be highly protected and there
will not actually be a WebTop on the boxes.
I'm actually thinking this sounds obvious - run a <cfcollection
action="OPTIMIZE" collection="SomeCollection"> against it, but then I
start thinking, "no, it's a Spectra content-object index and they're a
different sort of beast".
Can someone let me know whether the cfcollection option is likely to
work, or whether I need to do something else?
Steve
___________________________________________________________________
| Stephen Collins, Technical Consultant - ACIS (www.acis.com.au) |
| Allaire Certified ColdFusion 5 Developer |
| Ph +61 2 62822662 Fax +61 2 62824328 Cel +61 410 680722 |
| [EMAIL PROTECTED] [EMAIL PROTECTED] |
| ICQ UIN : 56321783 Yahoo! : trib |
|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~oOOo~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
| Are you building your best Body-for-LIFE? |
| www.bodyforlife.com |
|___________________________________________________________________|
______________________________________________________________________
Macromedia ColdFusion 5 Training from the Source
Step by Step ColdFusion
http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion
------------------------------------------------------------------------------
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.
