At 07:47 AM 5/31/01 -0800, you wrote:
>I don't know if it can do a db search. I'd suspect no, as its power is in
>burning through tons of text. But then, I've never seen why people use
>Verity for db searches.
It's faster than a table scan.
>The problem I see is that once your db is modified
>after you index your Verity collection, you are sitting on an inaccurate
>index.
True of files when they are updated, too.
>And yes you could re-index your collection every time the db is
>modified; but with that much going on, ya might as well execute your search
>directly in SQL anyway.
We update /DB/index every morning at 2a.
We do, however, use SQL 7 Full-text. A lot faster than Verity/CFAS 4.5.1.
Also, easier to combine SQL7 full-text search with ordinary SQL in one
step. With Verity it was a two-step process.
I'll be interested in what's said about Verity's K2.
best, paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
