Re: [sqlite] Performance increase between 3.7 and 3.8

2015-02-03 Thread Eduardo Morras
On Tue, 3 Feb 2015 06:39:02 -0700 (MST) Jan Slodicka wrote: > Eduardo Morras-2 wrote > > A ~8000MB db with app example data. More than 1000 query-corp > > created as part of test driven development of the app. We have > > precalculated the correct results in tables and its number

Re: [sqlite] Performance increase between 3.7 and 3.8

2015-02-03 Thread Jan Slodicka
Eduardo Morras-2 wrote > A ~8000MB db with app example data. More than 1000 query-corp created as > part of test driven development of the app. We have precalculated the > correct results in tables and its number of rows. No write, only read > queries and don't use other improvements like partial

Re: [sqlite] Performance increase between 3.7 and 3.8

2015-02-03 Thread Eduardo Morras
On Tue, 3 Feb 2015 02:43:00 -0700 (MST) Jan Slodicka wrote: > Eduardo Morras-2 wrote > > I use a big test db to assure new versions of sqlite works > > properly. With 3.7.15.2 it takes 43 minutes, with 3.8.8.2 on same > > hardware 27 minutes, it's 16/0.43 = 37% less or 27/0.43 =

Re: [sqlite] Performance increase between 3.7 and 3.8

2015-02-03 Thread Jan Slodicka
Eduardo Morras-2 wrote > I use a big test db to assure new versions of sqlite works properly. With > 3.7.15.2 it takes 43 minutes, with 3.8.8.2 on same hardware 27 minutes, > it's 16/0.43 = 37% less or 27/0.43 = 63% improve. Thanks, Eduardo. Could I ask you for a rough characterization of the

Re: [sqlite] Performance increase between 3.7 and 3.8

2015-02-03 Thread Jan Slodicka
Richard Hipp-3 wrote > From the description, your tests sound like you are pushing a bunch of > separate SQL statements into SQLite. In other words, the compute time > is likely dominated by the time need to parse the SQL and prepare > plans. Yes > Have you rerun the tests using prepared

Re: [sqlite] Performance increase between 3.7 and 3.8

2015-02-02 Thread Eduardo Morras
On Mon, 2 Feb 2015 10:08:36 -0700 (MST) Jan Slodicka wrote: > I know the reports about huge performance increase achieved within > the last year. (Compliments for that.) However, those numbers ignore > processor architecture and I/O. My question is a different one. > > What

Re: [sqlite] Performance increase between 3.7 and 3.8

2015-02-02 Thread Richard Hipp
On 2/2/15, Jan Slodicka wrote: > I know the reports about huge performance increase achieved within the last > year. (Compliments for that.) However, those numbers ignore processor > architecture and I/O. My question is a different one. > > What speed difference do you perceive in