indexing text fields in mysql ?
| From: | andy | Date: | Sun, 19 May 2002 16:04:33 +0000 |
| Subject: | indexing text fields in mysql ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19261@lists.php.net to get a copy of this message | ||
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