Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Full text reindexing - is there a faster way |
Tue, Jun 2 2009 9:18 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | As part of my app I allow people to adjust the full text indexing parameters (ie stop words, pass words, word length, delimiters and columns indexed). Is there a faster way to regenerate the indices once the parameters have been changed than to wizz through the Indexes (wince) and IndexColumns tables dropping and recreating them?
Roy Lambert |
Tue, Jun 2 2009 4:29 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< As part of my app I allow people to adjust the full text indexing parameters (ie stop words, pass words, word length, delimiters and columns indexed). Is there a faster way to regenerate the indices once the parameters have been changed than to wizz through the Indexes (wince) and IndexColumns tables dropping and recreating them? >> Not really. There are easier ways (REPAIR TABLE), but they are not faster. If you actually change some attribute of the text index, and not just the underlying custom word generation or filtering, then using ALTER INDEX will be faster than a DROP INDEX/CREATE INDEX cycle. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jun 3 2009 2:38 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Not really. There are easier ways (REPAIR TABLE), but they are not faster. >If you actually change some attribute of the text index, and not just the >underlying custom word generation or filtering, then using ALTER INDEX will >be faster than a DROP INDEX/CREATE INDEX cycle. Fair enough. I think that most changes will be to the parameters for the word generator so I'll just leave the code I've written alone. Roy Lambert |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |