Thanks for this. Will look into those :)
Appreciate the help
Ade
> Two things come to mind:
>
> 1) INDEX! And, since you're on MySQL, do a fulltext index of
> the column
>you're searching on.
>
> 2) Read up on the MATCH () ON () syntax in the MySQL documentation.
--
PHP General Mailing
Yup that is the solution, INDEX and match on
Octavio
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
"Adrian Teasdale" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi there
>
> I have been given the task of integrating a search into a database we
> have which contains 40 million records and I would really do with some
> advice! Thanks to everyone the other day who helped us parse
* Adrian Teasdale <[EMAIL PROTECTED]>:
> I have been given the task of integrating a search into a database we
> have which contains 40 million records and I would really do with some
> advice! Thanks to everyone the other day who helped us parse this same
> database into mysql.
>
> Basically the
4 matches
Mail list logo
