Re: innodb_checksum_algorithm stic_crc32 is slow response

[Ankur Kaushik]

Below is the query that was used , although I created combined Index device(device_serial_number,status) , That works for to make much faster query. now the result executes in 0.21 sec from 3-4 sec

My Concern is what I have read is that in MySQL 5.6 strict_crc32 is much faster read than innodb checksum , But in practically this shows more time taken to the query outout while not using Indexes

++++++++++++

select sql_no_cache CAST(trim(t.ticket_no) AS UNSIGNED) as ticket_no,CAST(trim(t.transaction_no) AS UNSIGNED) as transaction_no,ty.ticket_type_name, ifnull(tsy.ticket_sub_type_name,'') ticket_sub_type_name,t.schedule_no,t.route_no, ifnull(bs.bus_stop_name,' ') as from_stop_name,ifnull(bs2.bus_stop_name,' ' ) as till_stop_name, t.ticket_time, t.px_count, sum(t.px_total_amount) px_total_amount , t.lugg_units, sum(t.lugg_total_amount) lugg_total_amount,t.total_ticket_amount from etim_gprs_ticket t left join bus_stop bs on bs.bus_stop_id=t.from_bus_stop_id left join bus_stop bs2 on bs2.bus_stop_id=t.till_bus_stop_id left join ticket_type ty on ty.ticket_type_id=t.tkt_type_short_code left join ticket_sub_type tsy on tsy.ticket_sub_type_code=t.tkt_sub_type_short_code inner join device d on d.device_serial_number = t.etim_no and d.status = 'ACTIVE' and d.deleted_status = 0 where t.waybill_no='D1114120600086' and t.trip_no='1' and t.shift_no='2' and t.ticket_date = '07-12-2014' group by ticket_no order by ticket_no , transaction_no;