[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

2015-05-06 Thread Jay Smith
Nicolas there are other people who also receive this mail. if you have code that will help someone else. Please post the information Mr Hipp requested. Jay On Tue, Apr 28, 2015 at 5:08 PM, Nicolas Boullis wrote: > Hi, > > On Mon, Apr 20, 2015 at 06:25:21AM -0400, Richard Hipp wrote: > > > >

[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

2015-04-29 Thread Nicolas Boullis
Hi, On Mon, Apr 20, 2015 at 06:25:21AM -0400, Richard Hipp wrote: > > Please send us: > > (1) The output of "SELECT sqlite_source_id();" > > (2) The complete text of you SELECT statement. > > (3) The output of the ".fullschema" command from the most recent > version of the sqlite3.exe

[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

2015-04-20 Thread Eduardo Morras
On Mon, 20 Apr 2015 12:01:59 +0200 Nicolas Boullis wrote: > Hi, > > On Mon, Apr 20, 2015 at 11:18:56AM +0200, Clemens Ladisch wrote: > > If that does not help, we'll have to look at the actual queries (and > > their EXPLAIN QUERY PLAN output). > > That would certainly help, but I would have to

[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

2015-04-20 Thread Nicolas Boullis
Hi, On Mon, Apr 20, 2015 at 11:18:56AM +0200, Clemens Ladisch wrote: > > SQLite does not keep statistics automatically. Run ANALYZE. Thanks for the explanation. I just performed some measurements. When I use the database with PRIMARY KEY/UNIQUE constraints, the program uses 540s of CPU time

[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

2015-04-20 Thread Clemens Ladisch
Nicolas Boullis wrote: > I have a program that does mostly? SELECT requests, and it is very > slow. But I then figured out that, if I rebuild my SQLite database > without PRIMARY KEY/UNIQUE constraints, the program runs much faster > (no measurement yet, but I?d say at least 10? faster). SQLite

[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

2015-04-20 Thread Nicolas Boullis
Hi, Disclaimer: I am a PostgreSQL user and consider myself a SQLite newbie. I have a program that does mostly? SELECT requests, and it is very slow. But I then figured out that, if I rebuild my SQLite database without PRIMARY KEY/UNIQUE constraints, the program runs much faster (no

[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

2015-04-20 Thread Richard Hipp
On 4/20/15, Nicolas Boullis wrote: > Hi, > > On Mon, Apr 20, 2015 at 11:18:56AM +0200, Clemens Ladisch wrote: >> >> SQLite does not keep statistics automatically. Run ANALYZE. > > Thanks for the explanation. I just performed some measurements. > > When I use the database with PRIMARY KEY/UNIQUE