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
