> We added 1/2 million records to our database last night and > performanceon some searches has slowed to a crawl. I know part of > the issue can be > fixed using stored procedures, but some of the variable queries > are just > painful. Will Full-Text indexing on SQL Server help speed up these > searches?
Full text indexing only helps if you actually need to do searches using full text indexing. Is your transaction log on a separate physical drive than your data? Are you using RAID 0, 1, 0+1, 5? RAID 5 is extremely slow and generally not recommended for DBs Is your database normalized? Do you have proper indexes? Take a look at the execution plans of your queries. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
