CODEWITHSUNDEEP
coldfusioncoldfusion-9veritycfindex
Jim Cook
Jim Cook

Reputation: 13

ColdFusion 9 Verity Update

I have a usable Verity collection, initially populated thusly:

<cfindex action="refresh" type="custom" body="PageTitle,PageText" 
   collection="ABC" custom1="PageID" custom2="MenuName" 
   key="PageID" query="GetPages" title="PageTitle">

GetPages query looks something like this:

PageID  PageTitle       PageText   MenuName
-------------------------------------------
100     About XYZ Corp  <content>  About Us
200     XYZs Products   <content>  Products
300     XYZs Services   <content>  Services

Along comes a new page that needs to be added to the collection:

PageID  PageTitle       PageText   MenuName
-------------------------------------------
400     XYZ News        <content>  News

How do I add this to ABC without having to rebuild the entire collection? I've tried variations of <cfindex action="update" ...> without success, usually locking the collection and requiring a CF restart. I can't seem to find good working examples online, and what I do find seems vague. I can successfully purge and rebuild collection using <cfindex action="refresh"...>, but that's so process intensive to do regularly.

Environment: CF9 / IIS / WinServ 2008 R2; collection is ~300 documents at 1,500KB.

Limitations: app is in EOL phase so collection won't be migrated to SOLR; I have little experience using CF's search tools (engineers have done this for me up to now).

Upvotes: 1

Views: 107

Answers (0)

Related Questions