Hi,
SQL in general doe not make any guarantees about result ordering if you do not
sort them.
Use ORDER BY if you need to sort the results somehow. Otherwise expect nothing.
--
Gruesse,
Jakub
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-user
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
) and it gets better
from one release to the next. So I don't know why you are seeing a slowdown.
How do you measure?
On 8/24/15, Jakub Zakrzewski wrote:
> Hi All,
>
> I finally got a chance to upgrade SQLite for our product from ancient
> 3.7.16.2. Initial tests on Linux were v
15 5:21 AM, "Jakub Zakrzewski" wrote:
>
> Hi,
>
> The slowdown is confirmed by one of our customers. He uses Win 2008
Server x64. I'm testing on Win7 x64.
This might be obvious in which case my apologies for bringing it up but:
are these systems demonstrating slowness p
hat about fragmentation of the database itself? Does running VACUUM on the
database affect performance?
-Rowan
On 26 August 2015 at 16:16, Jakub Zakrzewski wrote:
> Hi,
>
> nope. The defragmentation job runs every Wednsday night and the
> fragmentation is very low.
>
> PS: I&
Hi,
I do it all the time - why not?
There are basically two approaches
1) download precompiled binary from SQLite website
2) compile it yourself.
As for the second one we use CMake for everything. The following little CMake
script does the job:
cmake_minimum_required(VERSION 2.8)
project(sqlite
-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
7 matches
Mail list logo
