MySQL Forums
Forum List  »  Partitioning

Re: Partitioning Table - GPS Data
Posted by: Rick James
Date: December 03, 2011 10:26AM

> KEY `IDX_DDL_PTP_IDR` (`VEI_ID`,`COORDINATE_DATE `,`PTP_IDR`),
is very efficient for doing
> WHERE COORDINATE_DATE between SUBDATE(#currentCoordinateDate#,2) AND #currentCoordinateDate#
> AND vei_id = #vehicleID#
The addition of PARTITIONing does not help anything for that SELECT.

Your previous attempt at PARTITIONing actually made _that_ SELECT worse. Your current PARTITIONing has no impact on the speed of _that_ SELECT.

You may be other reasons for PARTITIONing. For example, do you delete data that is over 11 months old by monthly DROPping and recreating the oldest partition?

Options: ReplyQuote


Subject
Views
Written By
Posted
3128
November 30, 2011 01:53PM
1512
November 30, 2011 03:15PM
1823
December 01, 2011 09:57PM
1419
December 02, 2011 08:51AM
Re: Partitioning Table - GPS Data
1557
December 03, 2011 10:26AM
1481
December 05, 2011 05:43AM
1736
December 06, 2011 08:46PM
1404
December 02, 2011 08:52AM


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.