Tac, Friday, September 27, 2002, 10:34:46 PM, you wrote: T> We're having a problem with a huge merge table and BETWEEN. The same query T> in MySQL 3, using an identical (binary) copy of the database, takes a T> fraction of a second, in MySQL 4.03 it runs without stopping.
T> The query is a simple "Select * from my_merge_table where my_code BETWEEN T> '2026676653' AND '2026676655'" T> If I run a simple script that loops through the invidiual tables of the T> merge table, using the same query (with each table), the response is very T> fast. And running the query when the operator is '=' instead of BETWEEN, T> everything is fine, e.g. T> Select * from my_merge_table where my_code = '2026676653' T> Expanding out the BETWEEN still causes the query to run forever: T> Select * from my_merge_table where my_code >= '2026676653' AND my_code T> <= '2026676655' I tested it on the not so big merge table (~ 150 000 rows) and it worked fine with BETWEEN. T> Another bug that's in MySQL 3 (that I haven't checked in MySQL 4) is trying T> to use a merge table where one of the tables has no rows. When we create a T> merge table, we go through each table first and check to make sure it has T> something in it, otherwise, the merge table is created ok but queries T> against it return no rows. Of course MySQL will check every table to check if it contains matched rows. T> Finally, does anyone know if you can now use fulltext indexes with a merge T> table? We're not yet (since it's not supported), but I did see that on the T> to-do list. Full-text search still works only on MyISAM tables. -- 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