,)]
[(None,)]
[(None,)]
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Thursday, 7 August, 2014 09:26
To: General Discussion of SQLite Database
Subject: Re: [sqlite] After ANALYZE all has become slow
On Fri, 8 Aug 2014 11:14:29 +0200, Giuseppe Costanzi
giuseppecosta...@gmail.com wrote:
sqlite3.sqlite_version
'3.5.9'
Version 3.5.9 is more than 6 years old. A lot of optimizations
were introduced since that version. Please upgrade and try
again.
--
Groet,
Kees Nuyt
...@sqlite.org] On Behalf Of Giuseppe Costanzi
Sent: Friday, 8 August, 2014 03:14
To: General Discussion of SQLite Database
Subject: Re: [sqlite] After ANALYZE all has become slow
using putty
Linux SRVXXX 2.6.26-2-686 #1 SMP Mon Aug 30 07:01:57 UTC 2010 i686
The programs included with the Debian GNU
To: General Discussion of SQLite Database
Subject: Re: [sqlite] After ANALYZE all has become slow
using putty
Linux SRVXXX 2.6.26-2-686 #1 SMP Mon Aug 30 07:01:57 UTC 2010 i686
The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program
Hi to everybody,
I have the following problem, on a database, 20M on a server linux, when I
make ANALYZE all the interrogations become slow.
The database is constituted by 37 tables, 56 views and varied indexes.
I use python database API 2.0 to talking with clients.
Considering that the data base
On 7 Aug 2014, at 10:56am, Giuseppe Costanzi giuseppecosta...@gmail.com wrote:
Hi to everybody,
I have the following problem, on a database, 20M on a server linux, when I
make ANALYZE all the interrogations become slow.
I'm very sorry, but I'm having a little trouble with your English and
On Thu, Aug 7, 2014 at 2:50 PM, Simon Slavin slav...@bigfraud.org wrote:
On 7 Aug 2014, at 10:56am, Giuseppe Costanzi giuseppecosta...@gmail.com
wrote:
Hi to everybody,
I have the following problem, on a database, 20M on a server linux, when I
make ANALYZE all the interrogations become
On 7 Aug 2014, at 3:24pm, Giuseppe Costanzi giuseppecosta...@gmail.com wrote:
I have finished running ANALYZE and SQLite commands are taking longer
only when I use python db api
such as
[...]
however I have done what you have pointed out me and in effects the
speed of execution
from the
,)]
[(None,)]
[(None,)]
[(None,)]
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Thursday, 7 August, 2014 09:26
To: General Discussion of SQLite Database
Subject: Re: [sqlite] After ANALYZE all has become