Verity should do a better job if your not already using it.
Rick
-----Original Message-----
From: Katrina Chapman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 10:09 AM
To: CF-Talk
Subject: SQL Server Index
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
