Re: Partitioning Table - GPS Data

[Daniel Alves]

Even if i add month in that select i cant get a fast result? On the new table my PK is - (`ID`,`VEI_ID`,`COORDINATE_DATE `,`DDL_CTM`,`MONTH`),

Like

SELECT (ddl_ct2 + 128)
FROM gps_data
WHERE COORDINATE_DATE between SUBDATE(#currentCoordinateDate#,2) AND #currentCoordinateDate#
AND `MONTH`= MONTH(#currentCoordinateDate#)
AND (ddl_ten + 128) * 0.5 > 8
AND vei_id = #vehicleID#
ORDER BY ddl_dh DESC
LIMIT 5

If i do a explain select partitions i got just one partition on the result.



Edited 1 time(s). Last edit at 12/05/2011 05:45AM by Daniel Alves.