Re: [sqlite] Please test the latest SQLite snapshot

2012-12-03 Thread John Gabriele 
On Mon, Dec 3, 2012 at 3:25 PM, Richard Hipp  wrote:
> A draft of the
> release website can be seen here:
>
>  http://www.sqlite.org/draft/index.html

Typo at the very beginning of http://www.sqlite.org/draft/about.html :
s/SQLite is a in-process library/SQLite is an in-process library/.

---John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Please test the latest SQLite snapshot

2012-12-03 Thread Richard Hipp 
We have received no performance regression reports for the SQLite 3.7.15
beta described below.  Hence, our intention is to move ahead with the
scheduled release of SQLite version 3.7.15 on 2012-12-12.  A draft of the
release website can be seen here:

 http://www.sqlite.org/draft/index.html
 http://www.sqlite.org/draft/releaselog/3_7_15.html

We want 3.7.15 to be a good release, so please do have a look at the
amalgamation snapshot described in the previous email (and copied below) if
you have not done so already, and let us know if you encounter any
problems.  In the absence of unanticipated problems, the 3.7.15 release
will come out one week from Wednesday.

On Fri, Nov 9, 2012 at 7:50 PM, Richard Hipp <d...@sqlite.org> wrote:

> Please test the latest snapshot of SQLite in your applications and report
> any performance regressions to this mailing list, or directly to me at
> d...@sqlite.org.   You can get a tarball or ZIP archive of the latest raw
> sources from Fossil at http://www.sqlite.org/src/info/trunk or you can
> pull down a snapshot of a recent amalgamation from:
>
> http://www.sqlite.org/download.html
> http://www.sqlite.org/sqlite-amalgamation-201211092140.zip
>
> We have made many improvements to the SQLite query planner/optimizer since
> the last release.  These enhancements should help to make most applications
> run faster.  But coding a query planner is more art than science, and so
> there is the possibility that some of the recent enhancements have made
> some corner-case queries run slower.  Unfortunately, the only way for us to
> identify those cases is to test SQLite in as many applications as possible.
>
> So, please do test the latest SQLite amalgamation in our applications, and
> please let us know if you encounter any performance regressions.  We cannot
> fix performance problems if we do not know about them.  Please do NOT wait
> until an official release to run this test - it will be too late then.
>
> FWIW, this email is being typed into Gmail running on a Firefox Nightly
> that was recompiled with the SQLite amalgamation snapshot shown above.  And
> the Fossil binary that you see at http://www.sqlite.org/src/timeline is
> also running the latest SQLite.  (See
> http://en.wikipedia.org/wiki/Eating_your_own_dog_food)  But we still need
> your help to test the latest SQLite enhancements in as many applications as
> possible.
>
> Thanks
>
> --
> D. Richard Hipp
> d...@sqlite.org
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Please test the latest SQLite snapshot

2012-11-10 Thread Elefterios Stamatogiannakis 

Hello,

We've been using SQLite 3.15-with-union-all-optimizations that you 
linked to previously, to run some of the workflows that we have here 
without problems.


The workflows use madIS, and they involve around 30 OLAP queries using 
row/aggregate/virtual table functions on ~5 GB of data.


No problems were found during the runs. The speeds were always the same 
or faster than before, and in some cases by changing some of the queries 
to fully use covering indexes they became many times faster (from ~1hour 
to 6-10 mins) [*].


We'll continue our testing with more data and we'll report back.

lefteris.

[*] Covering index optimizations are really amazing.

On 10/11/2012 2:50 πμ, Richard Hipp wrote:

Please test the latest snapshot of SQLite in your applications and report
any performance regressions to this mailing list, or directly to me at
d...@sqlite.org.   You can get a tarball or ZIP archive of the latest raw
sources from Fossil at http://www.sqlite.org/src/info/trunk or you can pull
down a snapshot of a recent amalgamation from:

 http://www.sqlite.org/download.html
 http://www.sqlite.org/sqlite-amalgamation-201211092140.zip

We have made many improvements to the SQLite query planner/optimizer since
the last release.  These enhancements should help to make most applications
run faster.  But coding a query planner is more art than science, and so
there is the possibility that some of the recent enhancements have made
some corner-case queries run slower.  Unfortunately, the only way for us to
identify those cases is to test SQLite in as many applications as possible.

So, please do test the latest SQLite amalgamation in our applications, and
please let us know if you encounter any performance regressions.  We cannot
fix performance problems if we do not know about them.  Please do NOT wait
until an official release to run this test - it will be too late then.

FWIW, this email is being typed into Gmail running on a Firefox Nightly
that was recompiled with the SQLite amalgamation snapshot shown above.  And
the Fossil binary that you see at http://www.sqlite.org/src/timeline is
also running the latest SQLite.  (See
http://en.wikipedia.org/wiki/Eating_your_own_dog_food)  But we still need
your help to test the latest SQLite enhancements in as many applications as
possible.

Thanks



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Please test the latest SQLite snapshot

2012-11-09 Thread Richard Hipp 
Please test the latest snapshot of SQLite in your applications and report
any performance regressions to this mailing list, or directly to me at
d...@sqlite.org.   You can get a tarball or ZIP archive of the latest raw
sources from Fossil at http://www.sqlite.org/src/info/trunk or you can pull
down a snapshot of a recent amalgamation from:

http://www.sqlite.org/download.html
http://www.sqlite.org/sqlite-amalgamation-201211092140.zip

We have made many improvements to the SQLite query planner/optimizer since
the last release.  These enhancements should help to make most applications
run faster.  But coding a query planner is more art than science, and so
there is the possibility that some of the recent enhancements have made
some corner-case queries run slower.  Unfortunately, the only way for us to
identify those cases is to test SQLite in as many applications as possible.

So, please do test the latest SQLite amalgamation in our applications, and
please let us know if you encounter any performance regressions.  We cannot
fix performance problems if we do not know about them.  Please do NOT wait
until an official release to run this test - it will be too late then.

FWIW, this email is being typed into Gmail running on a Firefox Nightly
that was recompiled with the SQLite amalgamation snapshot shown above.  And
the Fossil binary that you see at http://www.sqlite.org/src/timeline is
also running the latest SQLite.  (See
http://en.wikipedia.org/wiki/Eating_your_own_dog_food)  But we still need
your help to test the latest SQLite enhancements in as many applications as
possible.

Thanks

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users