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
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
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 =
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
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
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
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
7 matches
Mail list logo