SQL7 does full text indexing & search. Faster than Verity.
best, paul
At 04:08 PM 1/25/01 +0000, you wrote:
>Merry Meet,
>
>I have a small problem. I have a database, SQL Server 7.0, that has a
>collection of 22945 articles. This database grows by about 150 articles a
>day. The text of the articles are stored in text fields.
>
>I need to allow searching on the text field but with that many records it
>just lags. I wanted to create an index on that field to speed up the
>search, but since it is a text field and longer than 900 bytes SQL won't let
>me index it. Does anyone know how I can speed up the search?
>
>Blessed Be,
>--Katrina Chapman
>http://www.katrinachapman.com
>http://www.cfchick.com
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
