Question partition table in mysql

dxtr

Member
Joined
Oct 12, 2011
Messages
7
Programming Experience
Beginner
hey everyone :)
i have a table with 35millions row (id , trm , date_reception) , i'm having problems when i try to search for data between too dates it takes more than 4 minutes to execute the query , i read that you could solve this problem using partition but they were talking about creating new table ,
how to partition an already existing table with 5 Millions row for each partition (partition by id)
 
Back
Top