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? 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. Is there documentation on
the limitations of fulltext?
--
Regards,
Doug
---------------------------------------------------------------------
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
