Nicolas
there are other people who also receive this mail.
if you have code that will help someone else.
Please post the information Mr Hipp requested.
Jay
On Tue, Apr 28, 2015 at 5:08 PM, Nicolas Boullis wrote:
> Hi,
>
> On Mon, Apr 20, 2015 at 06:25:21AM -0400, Richard Hipp wrote:
> >
> >
Hi,
On Mon, Apr 20, 2015 at 06:25:21AM -0400, Richard Hipp wrote:
>
> Please send us:
>
> (1) The output of "SELECT sqlite_source_id();"
>
> (2) The complete text of you SELECT statement.
>
> (3) The output of the ".fullschema" command from the most recent
> version of the sqlite3.exe
On Mon, 20 Apr 2015 12:01:59 +0200
Nicolas Boullis wrote:
> Hi,
>
> On Mon, Apr 20, 2015 at 11:18:56AM +0200, Clemens Ladisch wrote:
> > If that does not help, we'll have to look at the actual queries (and
> > their EXPLAIN QUERY PLAN output).
>
> That would certainly help, but I would have to
Hi,
On Mon, Apr 20, 2015 at 11:18:56AM +0200, Clemens Ladisch wrote:
>
> SQLite does not keep statistics automatically. Run ANALYZE.
Thanks for the explanation. I just performed some measurements.
When I use the database with PRIMARY KEY/UNIQUE constraints, the program
uses 540s of CPU time
Nicolas Boullis wrote:
> I have a program that does mostly? SELECT requests, and it is very
> slow. But I then figured out that, if I rebuild my SQLite database
> without PRIMARY KEY/UNIQUE constraints, the program runs much faster
> (no measurement yet, but I?d say at least 10? faster).
SQLite
Hi,
Disclaimer: I am a PostgreSQL user and consider myself a SQLite newbie.
I have a program that does mostly? SELECT requests, and it is very
slow. But I then figured out that, if I rebuild my SQLite database
without PRIMARY KEY/UNIQUE constraints, the program runs much faster
(no
On 4/20/15, Nicolas Boullis wrote:
> Hi,
>
> On Mon, Apr 20, 2015 at 11:18:56AM +0200, Clemens Ladisch wrote:
>>
>> SQLite does not keep statistics automatically. Run ANALYZE.
>
> Thanks for the explanation. I just performed some measurements.
>
> When I use the database with PRIMARY KEY/UNIQUE
7 matches
Mail list logo