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 |
|
GreatInca
Posting Yak Master
102 Posts |
 Posted - 2001-11-09 : 20:52:06
|
| Currently it takes 8 seconds to run on 34KBs of text. It breaks up the words, checks them onthe wordlist files and inserts the non-matching ones. Then runs a query to get the suggestions (the bad words are already inthe table variable)Is there a faster way to get the words into a table or to do it fully set-based instead of a INSERT .. WHERE NOT EXISTS for each word? Getting the suggestions takes much less time (1 second) than getting the words into the table variable with the way it is now. But it does work and can feed the javascript code the data it needs to run. |
|
|
|
|
|
Boosting DB driven spell checker.