Re: partition and subpartitioning help

[deva clementraj]

which one will preforme good
if the
show status 'handler%'
gave me this
handler_read_next=7 and handler_read_rnd_next=49,08,079
when i partitioned table to_day(cols) with index ( id & timestamp)

i also created table with a partition of month(cols) with index
and i executed the select statement
the show status 'handler%'
show like this
handler_rad_next=20,35,953 and read_rnd_next=7
which one is better?

but the time taken is less for the partition table with to_days(cols),it takes 16.72265(2.8999)to give me the result

and partiton table with month(cols) it take more then the previous like 21.7464(0.1824)to give the result
which is better