Re: indexing text fields possible?

2002-05-21 Thread Jeremy Zawodny
On Mon, May 20, 2002 at 04:33:41PM +0200, andy wrote: Thank you Egor for you reply. I did read about indexing text column on the mysql site. So I tryed to index my column like described. After 1 hour, I had to reboot my machine because there was no other way. No other way? You could have

Re: indexing text fields possible?

2002-05-20 Thread Egor Egorov
andy, Sunday, May 19, 2002, 7:06:00 PM, you wrote: a I am wondering if it would be anyhow possible to make a search on a mysql a textfield faster. Right now the table contains 294000 entries and takes a about 40 MB of space. Is there a way to apply a index with a resonable a amount of disk

Re: indexing text fields possible?

2002-05-20 Thread andy
20, 2002 3:59 PM Subject: Re: indexing text fields possible? andy, Sunday, May 19, 2002, 7:06:00 PM, you wrote: a I am wondering if it would be anyhow possible to make a search on a mysql a textfield faster. Right now the table contains 294000 entries and takes a about 40 MB of space

indexing text fields possible?

2002-05-19 Thread andy
Hi there, I am wondering if it would be anyhow possible to make a search on a mysql 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