Check out full text searching:

Fast.  Accurate.


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 ([EMAIL PROTECTED])
 Netconcepts LTD - Auckland, New Zealand
 Linux: because rebooting is for adding hardware

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to