Our SQL 2000 DB runs on a Win 2K Server, which is a PIII, 500 MHz machine, having 512 MB RAM and 30 GB Hard Drive.
There is an application that searches for keyword matches in our database, and calls a stored procedure to perform the actual query. The tables being used are small, approx 12,000 rows each, and one of the columns is a text type column, with a full-text search index on it. I find that a single keyword search pushes up my CPU utilisation to 100% for 1-2 seconds, and a search on a number of keywords can push CPU usage to 100% for nearly 30 seconds. Even given that my query is fairly complex, involves a wildcard search on many columns, and uses a full-text search index on one of the columns, should performance be so poor given the hardware configuration I have ? Vishal. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
