On Tue, 31 Dec 2002, Frank Peavy wrote: > I asked the pattern match question, because I am using a hosting service > that hosts MySQL 3.23. Since I have a need to search on terms less than 3 > characters long and I can not re-compile, I was looking for another > solution. I thought that I might be able to use pattern matching as a > substitute, but it sounds like performance might be an issue with large tables. > > If you have any other recommendations on how I could approach my problem, I > would surely appreciate them.
Frank, consider to maintain a separate indexed table with all words from your texts together with a pointer to the row with the text containing the word. This shifts some work to the client, but works well as long as you avoid LIKE '%xyz'. Thomas Spahni --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
