Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  sql 7 full-text search, very slow on new machine

Author  Topic  mattd Starting Member 11 Posts Posted - 2001-04-28 : 09:59:53 Hi all, I'm experiencing performance problems with the full-text search engine in SQL 7. On our development machine, performance was good -- results were being returned in around 2-7 seconds. On our soon-to-be production machine, though -- with more RAM (1GB), faster processors, etc. -- the same full-text queries are taking around a minute, sometimes more, to execute. The full-text catalog is only 2MB, with 67,000 rows. In both cases, the OS is Windows 2000 Server, and in both cases I boosted SQL Server's priority. Right now, I'm the only one using either machine, so load is not an issue. Can anyone think of a reason this decrease in performance might be happening? I see a similar question was asked a week or two ago here, but none of the answers apply here -- I've looked at the sql-server-performance.com site. Thanks, matt