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

Reply via email to