Re: indexing text fields in mysql ?
| From: | Jason Morehouse | Date: | Sun, 19 May 2002 22:03:55 +0000 |
| Subject: | Re: indexing text fields in mysql ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19263@lists.php.net to get a copy of this message | ||
Check out full text searching:
http://www.mysql.com/doc/F/u/Fulltext_Search.html
Fast. Accurate.
Cheers,
-J
On Mon, 20 May 2002 04:04:33 +1200, Andy wrote:
> Hi there,
>
> I am wondering if it would be anyhow possible to make a search on a
> textfield faster. Right now the table contains 294000 entries and takes
> about 40 MB of space. Is there a way to apply a index with a resonable
> amount of disk space? I am also not so sure if I should use text or
> smalltext columns as the info may vary between 1 and 1000 chars.
>
> Thanx for any help on that,
>
> Andy
--
Jason Morehouse (jm@netconcepts.com)
Netconcepts LTD - Auckland, New Zealand
Linux: because rebooting is for adding hardware