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