-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The subject says it all...
We have a site content object type that represents "pages" on the
site. There are something in the range of 8000 objects of this type
and growing. Each of these objects has a number of attributes set as
"fulltext searchable" (i.e. Verity indexed). While it's fair to say
a lot of the pages these objects represent are small, some are pretty
large.
I have a scheduled task to conduct a weekly rebuild of the indexes
for the object. The task works, but the indexing seems to fall over.
I'm not sure how to get the indexing tag to spit a meaningful error.
What I'm seeing is:
* index deletion works (cfa_typeindexdelete)
* index creation works (cfa_typeindexcreate)
* index population dies (cfa_typeindex)
Looking at the box (big dual PIII-700 Xeon, 512Mb RAM, Windows 2000
Server, CF Enterprise 4.5.2, Spectra 1.5), what I see is that the
memory usage progressively ramps up until there is less than 1000Kb
available memory. Everything then grinds to a halt.
Is there some way to force the box to keep letting go of memory? Is
there another answer?
HELP!!!!
Script attached below. Tell me if I'm doing this badly, PLEASE!!!
Steve
========================================================
Stephen Collins, Technical Consultant - ACIS (Australia)
Work : [EMAIL PROTECTED] Personal : [EMAIL PROTECTED]
ICQ UIN : 56321783 Yahoo! : trib
"Before I got into triathlon, I was a normal person."
<!---
Template: /AFFAInternet/automation/reindex.cfm
Author: Stephen Collins, [EMAIL PROTECTED]
Date: Thursday, 12 July 2001 1:18:05 PM
Purpose:
Provide automated reindex facility.
Change History:
12/07/2001 swc initial version
- --->
<!-- begin reindex.cfm -->
<!--- system values --->
<cfset
ObjTypeList="#Application.Level2PageTID#,#Application.Level3PageTID#,#
Application.MediaReleaseTID#,#Application.NewsItemTID#">
<cfset CrLf= chr(13) & chr(10)>
<!--- loop over object types --->
<cfloop index="ThisType" list="#ObjTypeList#" delimiters=",">
<!--- create new logfile --->
<cfset TimeStamp="reindex" & ThisType & "_" &
DateFormat(Now(),"yyyymmdd") & TimeFormat(Now(),"HHmmss") &".log">
<cfset HeaderLine="FileName: #TimeStamp#" & chr(13) & chr(10) &
chr(13) & chr(10) & "Running scheduled reindexing task for all object
indices" & chr(13) & chr(10)>
<cffile action="WRITE"
file="#Application.RootPath#automation\logs\#TimeStamp#"
output="#HeaderLine#"
addnewline="Yes">
<!--- delete existing index --->
<cfa_typeindexdelete
typeID="#ThisType#"
dataSource="#request.cfa.objectstore.dsn#">
<cffile action="APPEND"
file="#Application.RootPath#automation\logs\#TimeStamp#"
output="Deleted index for #ThisType#.#CrLf#" addnewline="Yes">
<!--- create new index set --->
<cfa_typeindexcreate
typeID="#ThisType#"
dataSource="#request.cfa.objectstore.dsn#"
r_lCollectionsCreated="CollList">
<cfset CollLine=chr(13) & chr(10) & "- " &
Replace(CollList,",",chr(13) & chr(10) &"- ","ALL") & chr(13) &
chr(10)>
<cffile action="APPEND"
file="#Application.RootPath#automation\logs\#TimeStamp#" output="New
collection set for #ThisType# created. Collections are:#CollLine#"
addnewline="Yes">
<!--- do indexing --->
<cfa_typeindex
typeID="#ThisType#"
dataSource="#request.cfa.objectstore.dsn#">
<cffile action="APPEND"
file="#Application.RootPath#automation\logs\#TimeStamp#"
output="Indexing for #ThisType# complete.#CrLf#" addnewline="Yes">
<cffile action="APPEND"
file="#Application.RootPath#automation\logs\#TimeStamp#" output="End
of file. Job Complete." addnewline="Yes">
</cfloop>
<!-- end reindex.cfm -->
-----BEGIN PGP SIGNATURE-----
Version: PGP Personal Privacy 6.5.8
iQA/AwUBO1XuFH65o/U9+lJVEQLVCwCgloZ/4AP/6XfBL9t0pJSnyppJyz4AmwSF
9TP+JoUYr8Bptycd5d5QTWUT
=WoZp
-----END PGP SIGNATURE-----
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
