> collection thru action = ''t necessarily sound "correct" or "incorrect". It's certainly
possible.
Without getting into whether Verity sucks or not, there are things that
Verity is good at, and things that it's not so good at. Verity indexes are
static, rather than dynamic (like database indexes typically are), and in my
experience the indexing procedure can often be very slow. You can speed
searches by using K2, but indexing from your CF application can only use the
VDK interface, which is much slower for searching than K2 (so, naturally, I
imagine that it's probably slower at indexing as well, although that's just
my assumption).
So, whenever I work with Verity for anything serious, there are a few
guidelines I like to follow when I can.
First, if possible, indexes shouldn't reflect real-time data changes if they
don't have to. This allows you to perform indexing at off-peak hours, or
even offload indexing onto another server perhaps.
Second, for searching, always use the K2 interface if you won't exceed the
licensing limitations. If you will exceed those limitations (250,000
documents maximum, I think), you should either have a full K2 license or
find another solution, since the VDK search interface is comparatively slow.
Third, keep collections optimized. This involves a couple of things.
Typically, I like to set up a routine to completely purge and reindex all
content within a collection on a regular basis (usually daily). I much
prefer this approach to the alternative of updating a collection one
document at a time, as new documents are added. Disk fragmentation seems to
negatively impact performance quite a bit, for both indexing and searching,
in my experience, so you want to avoid that as well.
Fourth, consider a "leapfrog" index scheme. This involves duplicate
collections, in which you provide one searchable collection (or set of
collections) while optimizing/rebuilding/whatever the "offline" collections.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
