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.
| Author |
Topic |
|
jadoger
Starting Member
13 Posts |
 Posted - 2004-08-23 : 04:44:26
|
| Operating System: Windows 2000 ServerServer Brand: DELL (Intel Penium 111, 1133 MHz)Sql Server Standadrd EditionRam: 2GBProcessor: 1Fulltext Index Size: 52MBNumber Of Rows In Table: 1.2 Million AproxSQL SERVER MEMORY SETTINGS: FIXED, 1945 MBMINIMUM QUERY MEMORY SETTING: 1048576 KBAverage Records Processing Per Minute : 7.2Average Records Processing Per Hour : 72Target NUmber Of Rows: 1.1 Millionstored procedure i am using is used to remove duplications from the contacts list, I altered the few parts of stored procedure and checked every statement using profiler,the only one taking long time to execute is the FULL TEXT SEARCHES one,SELECT Contact_ID From Contact22 conWHEREcon.Gender = @vOuterGenderAND (Con.Reported = 0 or con.reported is null)AND Contains(con.zip,@vOuterZip)AND Freetext(Address, @vOuterAddress)AND Freetext(Con.Full_Name,@vOuterName)as i mentioned that I have 1.1 million rows table on which fulltext is enabled on three cloumnsAddress,zip and Fullname (total size after full population is 52MB)so what all my stored procedure does is take every record from the contact table and matches it against others presnet in the table(1.1 million rows) using fulltext searches, now these full text searches are taking time!!!Currrenlty with all the settings I mentioned above my virtual memory is set to 1.5 times then the actual RAM, my database and full text indexes are on the same drive(thats the only choice) and it is execting at the speed of20000 rows in 24 hours which means it required almost 55 days to finish, unacceptable.....can any one tell me that how to improve the performance in a senario like mine for full text seaches? or is it the standard speed every one gets from full text searches ? |
|
|
|
|
|
|
|
Full Text Search Performance Required