Question about verity 2

[snix1]

Hi! I have a rather large collection of indexed articles. It is now running quite slow...I know that CFINDEX can reindex this collection or I can OPTIMIZE it...what exactly is the difference. I assume when you reindex a collection, it is optimized as well. Is this true?

Also, can I use the CFCOLLECTION tag instead of doing everything through CF ADMINISTRATOR? I want to write a template to reindex/optimize the collection periodically off hours. In the past, I've always used CF Administrator to do this.

Thanks for your help.

 

[JNC73]

Well I cant exactly tell you the diffirence but what I do know is that when you Reindex the collection the collection is optimized in a way that every query on the collection takes as much time. When you don't perform a reindex for a long time every new article is appended on the index on one side of the tree it created. Therefor if you search for something on that side it will take a long time.

When you reindex the tree it made before will be optimized again so that every query uses as much time.

Optimize means generaly that when a tree is reindexed and every search uses the same amount of time, but that is still too long. You can optimize the query to produce the result a lot faster. How this can be done I cant tell you.

Hope this helps

JNC73

 

[CFHub]

You may want to occasionally "purge" your collection, then re-index it. Purging/re-ndexing takes a little longer than optimizing but... it seems to work better for me.

Yes, you can do it via script, and can also use a scheduled task.

A heads up on CFSchedule:

http://cfhub.com/advanced/cfschedule/

Some Verity Info (and a complete Verity app):

http://cfhub.com/advanced/verity/index.cfm