MySQL Forums
Forum List  »  Partitioning

Partitioning dilemma
Posted by: Philopator Ptolemy
Date: July 20, 2010 08:51AM

I’m faced with a dilemma of choosing the right type and key for partitioning.
We have 2 very big tables in the system: sessions and transactions. One session can have many transactions.

Application actively inserts into both these tables and queries them by ID PK.
Back-office on the other hand queries those tables by DATE of the session and/or transaction.

This means that I have to choose whether to partition it by ID or by DATE.

Are there any compromise solutions?
Also I read somewhere that partitioning with PK on the table does not really help the performance and can actually make it work because large PK index cannot be kept in RAM.

Any help or advice is much appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Partitioning dilemma
2748
July 20, 2010 08:51AM
1566
July 21, 2010 11:58AM
1441
July 21, 2010 01:47PM
1540
July 26, 2010 11:15PM
1386
July 27, 2010 09:02AM
1453
July 27, 2010 08:06PM


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.