I would like to try this too. This would certainly be a cheaper alternative
than
Texis. If you don't mind, could you email me the code to use this off list.
James
[EMAIL PROTECTED]
-----Original Message-----
From: Tom [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 11:10 AM
To: [EMAIL PROTECTED]
Subject: Re: Verity vs. Freetext
A product I use for full-text indexing and searching is called textdb
(www.webest.dk)
It's a small and cheap product. It's not as straight-forward to use as
mssql fulltext, but it's furociously quicker than mssql or oracle (and
presumably verity with comparisons of it being slower than sql7).
I have a db with 500,000 records containing descriptions ranging from 5k to
1 meg of data, and ANY search I do is finished within half a second. I can
do a wildcard "a" search, or a very complex conditional query using "sounds
like" operators, and still get my results back in that amount of time. Not
sure if version 4 is out yet, but version 3.whatever didn't support phrases,
the new version does (and is just as quick as before).
Building the full text index also blows away the competition. It's not as
rich in features as teh others, and has a couple other limitations - but raw
speed (both building, updating, and retrieving) blows ms sql and oracle
(context stuff and intermedia) out of the water. I can build an index in
about 20 minutes on multiple fields against the 500k record database - this
is from scratch.
It works as a com object, so you need to use cfobject (which I have sample
code for it) - but this still works very quickly.
Not sure about how it works with thai, but it's very impressive nonetheless.
well, that's my 2 cents.
Tom
----- Original Message -----
From: Paul Hastings <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 10, 2000 12:13 PM
Subject: Re: Verity vs. Freetext
> > Which would be faster - a verity collection, or using SQL 7's Full-text
> > indexing? We are probably talking about well over 20,000 individual
> > records.
>
> i didn't see any answers to this so...from our work sql server 7
> full text indexing beats verity flat out if you have to come back
> to the db for row details. besides the obvious hit of having to
> re-query the db, verity doesn't cache queries, etc. its also a
> shotgun search thru the "body" of your text data which may be
> from several columns & thus hard or impossible to id. on top of
> that verity doesn't work w/thai language ;-)
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
