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

Reply via email to