Re: help with big table search

2002-02-25 Thread Jaime Teng
. Thanks, --jeff - Original Message - From: Luke Muszkiewicz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 24, 2002 6:30 PM Subject: RE: help with big table search Jaime: Have you tried creating a FULLTEXT index? If so, I'd like to hear about how well it works

RE: help with big table search

2002-02-24 Thread Daniel Rosher
Jamie, I think your approach of a cross-reference table is a good start. This is similar to creating a stemming index. Perhaps you might like to look into, for example, some perl Modules for stemming (like Linga::Stem) to further reduce your data space. Perhaps since there may be a large

RE: help with big table search

2002-02-24 Thread Luke Muszkiewicz
Jaime: Have you tried creating a FULLTEXT index? If so, I'd like to hear about how well it works on such a large database. http://www.mysql.com/doc/F/u/Fulltext_Search.html Best of luck. -luke Luke Muszkiewicz Pure Development, LLC http://puredev.com Hi, I have a table and currently has

Re: help with big table search

2002-02-24 Thread Jeff Kilbride
PROTECTED] Sent: Sunday, February 24, 2002 6:30 PM Subject: RE: help with big table search Jaime: Have you tried creating a FULLTEXT index? If so, I'd like to hear about how well it works on such a large database. http://www.mysql.com/doc/F/u/Fulltext_Search.html Best of luck. -luke