On Fri, 28 Aug 2015 12:55:00 +
Jakub Zakrzewski wrote:
> Hi,
>
> just and update here.
> It seems that the newer libraries perform worse when we use multiple
> worker threads. I don't know why and I don't have time to investigate
> it any further. We'll stay with the old 3.7.16.2 for now.
P
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jakub
Zakrzewski
Sent: Mittwoch, 26. August 2015 13:51
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Performance problems on windows
inglists.sqlite.org] On Behalf Of Rowan
Worth
JZ> Sent: Mittwoch, 26. August 2015 13:33
JZ> To: General Discussion of SQLite Database
JZ> Subject: Re: [sqlite] Performance problems on windows
JZ> What about fragmentation of the database itself? Does running
JZ> VACUUM on the database
linglists.sqlite.org [mailto:
> sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Scott Robison
> Sent: Dienstag, 25. August 2015 18:55
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Performance problems on windows
>
> On Aug 25, 2015 5:21 AM, "Jakub Z
Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Rowan Worth
Sent: Mittwoch, 26. August 2015 13:33
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Performance problems on windows
W
al Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Scott Robison
Sent: Dienstag, 25. August 2015 18:55
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Performance problems on windows
On Aug 25, 20
On 25 Aug 2015, at 9:52am, Jakub Zakrzewski wrote:
> Thanks for interest. If I can provide any useful information, just tell me,
> what you need. I cannot reveal the source code but some profiling results or
> SQL statements are not a secret.
Can you provide a short series of SQL statements w
kub
>
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:
sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Richard Hipp
> Sent: Dienstag, 25. August 2015 03:19
> To: General Discussion of SQLite Database
> Subject: Re: [sqlit
atements are not a secret.
--
Gruesse,
Jakub
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp
Sent: Dienstag, 25. August 2015 03:19
To: General Discussion of SQLite Database
Subject: Re: [sqlite
On 8/25/15, Jakub Zakrzewski wrote:
> If I can provide any useful information, just tell me,
Perchance, do you have a reproducible test case that you can share?
Have you considered adding timers on individual SQL operations to see
which ones are slower and/or faster?
Can you record all SQL ope
I don't have any clues.
While most of our work happens on Linux, we do measure performance on
Windows from one release to the next (see for example item 23-b on the
most recent release check-list
https://www.sqlite.org/checklists/private/3081100/index#c23) and it
gets better from one release to th
Hi All,
I finally got a chance to upgrade SQLite for our product from ancient 3.7.16.2.
Initial tests on Linux were very promising - ranging from 33% to even 300% (for
one degenerated case) speed improvement. So far so good. Problems begun when I
have tested it on Windows. Depending on test cas
12 matches
Mail list logo
