MySQL Forums
Forum List  »  Partitioning

Performance of multiple separate tables better than that of multiple partitions?
Posted by: Thorsten Mueller
Date: March 13, 2007 02:09AM

Hi,

I have a general question regarding performance: Are partitioned Tables equal to the same number of independent tables regarding performance?

Maybe I can explain my problem by an example:

I have a created a table "Hits" with more than 50.000.000 lines refering to 5 different "categories". (Referencing uses a secondary key=int in both cases).

There are two possibilities:

Partitioning the large "Hits" table in say 5 partitions by using KEY partitioning on a secondary key in the Hits table.

The other possibility would be to create 5 different "Hits" tables for each kategory ("HitsA", "HitsB", ...).

The usecases I am thinking of are thousands of INSERTS into the "Hits" tables or a multitute of Select queries like "SELECT h.* from Hits h, Kategory k where k.id = xy AND h.kategory_id = k.id "


It would be great if anybody could help me with this problem.

Thanks,

Thorsten

Options: ReplyQuote


Subject
Views
Written By
Posted
Performance of multiple separate tables better than that of multiple partitions?
4287
March 13, 2007 02:09AM


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.