MySQL Forums
Forum List  »  Merge Storage Engine

Re: Merge table performance
Posted by: Alastair Smith
Date: July 21, 2005 01:38AM

Hi KimSeong,

I’ve tested this again by removing the LIMIT clause from each query and now get the results that I was expecting;

Query 1 (without LIMIT 1) on base table 1 returns in 13 seconds
Query 1 (without LIMIT 1) on merge table returns in 13 seconds
Query 2 (without LIMIT 1) on base table 2 returns in 26 seconds
Query 2 (without LIMIT 1) on merge table returns in 26 seconds

Note that sorting the data by ORGANISATION_ID, before loading the data into the table, (the indexes are already sorted) has a dramatic affect on the queries which use a LIMIT clause.

Query 1 on base table 1 returns in 0.01 seconds
Query 1 on merge table returns in 0.01 seconds
Query 2 on base table 2 returns in 0.01 seconds
Query 2 on merge table returns in 14 seconds

Many thanks for your help here.

Regards,
Alastair.

Options: ReplyQuote


Subject
Views
Written By
Posted
9836
July 19, 2005 09:13AM
5102
July 19, 2005 11:37PM
4831
July 20, 2005 12:58AM
Re: Merge table performance
4725
July 21, 2005 01:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.