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. All the cpu was bussy and it seemed to me to be an endless loop. After rebooting I had to repair the file system (suse72) and tables. There was also a 130 MB tmp file I deleted.
So what did I do wrong, or does it just take that long? The table contains about 40 MB of space. Andy ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 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. Is there a way to apply a index with a resonable > a> amount of disk space? > > For TEXT column you can index only prefix of the column. > > a> I am also not so sure if I should use text or > a> smalltext columns as the info may vary between 1 and 1000 chars. A query for > a> LIKE 'test%' takes about 20 s right now. > > There is no SMALLTEXT column type in MySQL :) There are TINYTEXT, > TEXT, MEDIUMTEXT and LONGTEXT. > > TINYTEXT allows to store L+1 bytes, where L < 256 bytes. So > it's not quite enough for you ... > > Take a look at: > http://www.mysql.com/doc/n/o/node_369.html > You can find info about storage requirements there. > > a> Thanx for any help on that, > a> Andy > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php