Re: [sqlite] Slow select from database

2014-03-12 Thread Simon Slavin
On 12 Mar 2014, at 10:38am, Георгий Жуйков wrote: > 1 . We have a database of measurements: time DATETIME, name TEXT, value > NUMERIC > indexes: > 'tags_name_index' ON 'TAGS' ('NAME' ASC) > 'tags_name_itemtime_index' ON 'TAGS' ('NAME' ASC ', ITEMTIME' ASC) > In case of record auto_vacuum=INCREM

Re: [sqlite] Slow select from database

2014-03-12 Thread Niall O'Reilly
At Wed, 12 Mar 2014 14:38:15 +0400, Георгий Жуйков wrote: > > 1 . We have a database of measurements: time DATETIME, name TEXT, value > NUMERIC > indexes: > 'tags_name_index' ON 'TAGS' ('NAME' ASC) > 'tags_name_itemtime_index' ON 'TAGS' ('NAME' ASC ', ITEMTIME' ASC) > In case of record auto_vacuu

Re: [sqlite] Slow select from database

2014-03-12 Thread Valentin Davydov
On Wed, Mar 12, 2014 at 02:38:15PM +0400, Георгий Жуйков wrote: > 1 . We have a database of measurements: time DATETIME, name TEXT, value > NUMERIC > indexes: > 'tags_name_index' ON 'TAGS' ('NAME' ASC) > 'tags_name_itemtime_index' ON 'TAGS' ('NAME' ASC ', ITEMTIME' ASC) > In case of record auto_va