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

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