Sqlite 3.27 slow than 3.22

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Sqlite 3.27 slow than 3.22

Jorge Mason
Dears,

Why Sqlite 3.27 it's more slow than Sqlite 3.22

The next Query in Sqlite 3.22 cost 6.47 seconts and 20.3 seconds on Sqlite 3.27

Table with 732.000 records

select strftime('%Y',fecha) as Ano, strftime('%m',fecha) as Mes, sum(Duracion) as Duracion,sum(Costo) as Costo,sum(1) as Cantidad from Llamada where Estado = 'AC' group by strftime('%Y',fecha),strftime('%m',fecha) order by strftime('%Y',fecha),strftime('%m',fecha)


Many thanks in advance
Jorge Mason