performance issue

1 post / 0 new
haresh.patel
haresh.patel's picture
Offline
Last seen: 5 months 5 days ago
Joined: Oct 8 2013
Junior Boarder

Posts: 2

Haresh Patel
performance issue

After setting infinidb_vtable_mode = 2

a normal min and max on timestamp query take 1 minutes.

query = select min(timestamp) , max(timestamp) from data_table;

------------------------------------------------------------------------------------------------------------------------------------
query calsettrace
------------------------------------------------------------------------------------------------------------------------------------
Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows
BPS PM base_hourly_kpi_data 3518 (timestamp) 2383203 2410408 0 70.726 300717
TAS UM - - - - - - 70.626 1
------------------------------------------------------------------------------------------------------------------------------------

suggest performance tunning parameter or alternate solution....

thanks in adavance