Re: Switching from 3.22.32 to 3.23.33. What about the database files?

2001-02-16 Thread Karl Sloth
Tobias - You can continue to use the ISAM format or convert to the new MYISAM format (and other formats such as HEAP, I believe). See the 'mysql_convert_table_format' script in the bin directory. -karl Tobias Wolff wrote: Hello, can anyone tell me whether or not I have to convert the

sometimes hanging queries

2001-02-15 Thread Karl Sloth
I've been having a problem for quite awhile now with a particular query sometimes taking a long time. The query in question is a web-based search for messages in a bbs archive. Every time a message is added to the bbs each word in the message is parsed out and added to the

sometimes hanging query - more info

2001-02-15 Thread Karl Sloth
* I left out a piece of probably important information the first time: search_messages_archive contains 11.5 million records. messages_archive contains 760,000 records. Thanks. -karl