# Tokudb Partioning Advantage

**URL:** <https://forums.percona.com/t/tokudb-partioning-advantage/4675>\
**Category:** Other MySQL® Questions\
**Created:** [January 20, 2016, 6:00am UTC](https://forums.percona.com/t/tokudb-partioning-advantage/4675 "2016-01-20T06:00:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sergio\_Sanchez](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergio_sanchez/32/6575_2.png) [@Sergio\_Sanchez](https://forums.percona.com/u/Sergio_Sanchez)\
**Post date:** [January 20, 2016, 6:00am UTC](https://forums.percona.com/t/tokudb-partioning-advantage/4675/1 "2016-01-20T06:00:18Z")

</div>

Hi,

I have a Time Series Database with over 2.500 Million registers  
The structure is the following.

I would like to have some advice to improve efficiency.  
I wonder If it would be a good idea to partition the data by month or by year ? All queries are monthly or yearly based.  
Any idea is welcome.

Thanks.