RE: [PHP] Re: Large database, slow search times
| From: | Adrian Teasdale | Date: | Fri, 03 Sep 2004 06:19:28 +0000 |
| Subject: | RE: [PHP] Re: Large database, slow search times | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-195683@lists.php.net to get a copy of this message | ||
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.