[sqlite] Performance issue

Hi everyone, I have copied the original database on my personnal website in a tbz archive here : http://nice-waterpolo.com/misc/db/ There is only one index on timestamp,protocol. Thanks. 2015-04-08 14:38 GMT+02:00 R.Smith : > > > On 2015-04-08 01:57 PM, Dominique Devienne wrote: > >> No

[sqlite] Performance issue

ing the query planner into some > wrong decisions (if you have an index with protocol as the first column). > > And how about WAL mode? If concurrency is of any concern for you, this > definitely is something worth a try. > > -- GB > > > Jeff Roux schrieb am 31.03.2015 um

[sqlite] Performance issue

oto ON flows(protocol); CREATE INDEX idxTos ON flows(tos); CREATE INDEX idxTsLanWan ON flows(timestamp, ipLan, ipWan, portWan, portLan); CREATE INDEX tsindex ON flows(timestamp); 2015-03-30 12:44 GMT+02:00 Jeff Roux : > Simon, > > here is the list of the indexes that were already defined

[sqlite] Performance issue

_ENABLE_STAT4 enabled? If not, > give it a try. It sometimes makes a big difference. > > Is it possible that data collection and retrieval happen at the same time? > If so, try running the database in WAL mode, it should help with > concurrency issues. > > -- GB > > >

[sqlite] Performance issue

IT 6; 0|0|0|SEARCH TABLE flows USING INDEX ts4 (protocol=? AND timestamp>? AND timestamp: > > On 30 Mar 2015, at 10:46am, Jeff Roux wrote: > > > This daemon is running on a HP server with 12 cores, 32 GB of RAM, > > and a SSD drive. I have performance issues wit

[sqlite] Performance issue

Hi everyone, I have a daemon that collects information and stores it in a SQLite database. The table has 1 million rows. This daemon is running on a HP server with 12 cores, 32 GB of RAM, and a SSD drive. I have performance issues with some requests. For instance, the following request takes