Re: [sqlite] Very slow processing of some SELECT statements

2011-10-18 Thread Simon Slavin
On 18 Oct 2011, at 6:46am, Sylvain Pointeau wrote: > Is it normal that fromuid of the table exits is STRING ? > I think it should be TEXT to be surely processed as text and not float If you're writing your database especially for SQLite you should specify 'TEXT' not 'STRING'. However, SQLite

Re: [sqlite] Very slow processing of some SELECT statements

2011-10-18 Thread Sylvain Pointeau
On Tue, Oct 18, 2011 at 8:30 AM, Nick Gammon wrote: > > On 18/10/2011, at 4:46 PM, Sylvain Pointeau wrote: > > > Is it normal that fromuid of the table exits is STRING ? > > I think it should be TEXT to be surely processed as text and not float > > That was an error. However

Re: [sqlite] Very slow processing of some SELECT statements

2011-10-18 Thread Nick Gammon
On 18/10/2011, at 4:46 PM, Sylvain Pointeau wrote: > Is it normal that fromuid of the table exits is STRING ? > I think it should be TEXT to be surely processed as text and not float That was an error. However it shouldn't take SQLite 2.5 seconds to handle *any* numeric literal. Especially as

Re: [sqlite] Very slow processing of some SELECT statements

2011-10-17 Thread Sylvain Pointeau
Is it normal that fromuid of the table exits is STRING ? I think it should be TEXT to be surely processed as text and not float ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Very slow processing of some SELECT statements

2011-10-17 Thread Nick Gammon
On 18/10/2011, at 3:38 PM, Dan Kennedy wrote: > Now fixed here: > > http://www.sqlite.org/src/ci/59bb999c8b?sbs=0 Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Very slow processing of some SELECT statements

2011-10-17 Thread Dan Kennedy
On 10/18/2011 03:17 AM, Nick Gammon wrote: On 17/10/2011, at 9:55 PM, Dan Kennedy wrote: Did you download the binary from the website or build it yourself? If the latter, which compiler are you using? And what level of optimization is enabled? I initially observed the problem with version

Re: [sqlite] Very slow processing of some SELECT statements

2011-10-17 Thread Nick Gammon
On 17/10/2011, at 9:55 PM, Dan Kennedy wrote: > Did you download the binary from the website or build it yourself? > If the latter, which compiler are you using? And what level of > optimization is enabled? I initially observed the problem with version 3.7.7.1, as embedded in my application

Re: [sqlite] Very slow processing of some SELECT statements

2011-10-17 Thread Dan Kennedy
On 10/17/2011 04:33 PM, Nick Gammon wrote: Hello, Running under Windows XP, using sqlite3.exe version: 3.7.8 2011-09-19 14:49:19 3e0da808d2f5b4d12046e05980ca04578f581177 ... Trying under Mac OS/X (Lion) does not appear to exhibit this problem. No problem with that version on Linux either.

Re: [sqlite] Very slow processing of some SELECT statements

2011-10-17 Thread Simon Slavin
On 17 Oct 2011, at 10:33am, Nick Gammon wrote: > Running under Windows XP, using sqlite3.exe version: > > 3.7.8 2011-09-19 14:49:19 3e0da808d2f5b4d12046e05980ca04578f581177 [snip] > > Trying under Mac OS/X (Lion) does not appear to exhibit this problem. Just a note that the version of the

Re: [sqlite] Very slow processing of some SELECT statements

2011-10-17 Thread Nick Gammon
On 17/10/2011, at 8:33 PM, Nick Gammon wrote: > ... > The following SQL: > > ... > SELECT * FROM exits WHERE fromuid = '2E515665758C87202B281C7FC'; > > > Takes over 2 seconds to execute (in particular, the SELECT statement). > Further to the above, changing the column type from

[sqlite] Very slow processing of some SELECT statements

2011-10-17 Thread Nick Gammon
Hello, Running under Windows XP, using sqlite3.exe version: 3.7.8 2011-09-19 14:49:19 3e0da808d2f5b4d12046e05980ca04578f581177 As follows: sqlite3 foo.db The following SQL: DROP TABLE IF EXISTS rooms; DROP TABLE IF EXISTS exits; CREATE TABLE IF NOT EXISTS rooms (