Re: [sqlite] Optimizing aggregation queries

[Simon Slavin]

On 23 Nov 2018, at 3:44pm, Wout Mertens  wrote:

> CREATE TABLE log(type TEXT, amount INTEGER)
> SELECT type, SUM(amount), COUNT(*) FROM log GROUP BY type
> 
> What would be good approaches to make the query fast?

Create an index for "log(type, amount)".

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Optimizing aggregation queries

[Wout Mertens]

Given a logging table:

CREATE TABLE log(type TEXT, amount INTEGER)
SELECT type, SUM(amount), COUNT(*) FROM log GROUP BY type

What would be good approaches to make the query fast?

Wout.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users