Stephen,
Just a side note, I hope you are locking the application var reads, or
making sure that there are never any writes taking place after the
first
application hit takes place, or this could corrupt, but anyway.
Have you though of doing your verity updates incrementally, like,
************
<cfquery name="qGetObjects" datasource="#Request.cfa.datasource.dsn#">
select objectid
from objects
where typeid = '#typeid#'
and DATETIMELASTUPDATED > '#lastIndexUpdate#'
</cfquery>
<cfif qGetObjects.recordcount>
<cfset lobjectids = valuelist(qGetObjects.objectid)>
<cfa_typeindexkeyupdate typeID="#typeid#" lObjectIDs="#lobjectids#"
dataSource="#Request.cfa.datasource.dsn#">
<cfa_metadataindexupdate lObjectIDs="#lobjectids#"
datasource="#Request.cfa.datasource.dsn#">
</cfif>
************
This will update the verity index for every object updated since the
last
time the update was run, all you have to do is store the last updated
time
to file, and off you go, you may also wish to make the
lastIndexUpdate =
lastIndexUpdate - 1 hour or something to pick up changes that took
place
while the script is running...
Hope that is of some use.
Cheers,
Aaron.
/****************************************
Aaron Shurmer
Senior Developer
Daemon Internet Consultants
ph +61 (0) 2 9380 4162
http://www.daemon.com.au/
engineered.innovation
****************************************/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
