Hi!
On Sep 07, Doug Poland wrote:
> On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote:
> > Lorang Jacques ([EMAIL PROTECTED]) writes:
> >
> > > Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> > > tables. As it is quiet some work, I first want to ask you guys if this
> > > is really going to make my queries faster (much faster ?)
> > >
> >
> > Yup. I've got the entire set of laws for the State of Texas online.
> > My query time went down from 120 seconds to less than a second.
> > So, yes, it's really worth it.
> >
> Do the current limitations of 500 characters per index and limited (?)
> number of columns per index pose problems?
Limited number of columns restriction applies to FULLTEXT indexes as well
(I think).
500 char/index limitation does not .
> I want to use fulltext
> on a database with 7 varchar(255) columns and several smaller varchar
> columns but can't build a fulltext index.
What was your problem, exactly ?
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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