[sqlite] Speeding up the UPSERT by using ISNULL instead of COALESCE in the subselect

Good morning, Could anyone tell me if I should replace COALESCE with ISNULL in the subselect in order the improve the speed of the following UPSERT: INSERT OR REPLACE INTO FREQMARY(Value, NumericValue, DateTimeValue, Count, Length) VALUES ('Braintree Road',NULL,NULL, COALESCE((SELECT Count+1 FROM

Re: [sqlite] Speeding up the UPSERT by using ISNULL instead of COALESCE in the subselect

Frank Chang wrote: > Could anyone tell me if I should replace COALESCE with ISNULL in the > subselect A COALESCE with two parameters behaves identical to IFNULL. > in order the improve the speed There will be no difference. (Except that IFNULL saves two characters in the SQL command string.

[sqlite] spelling in sqlite3.c version 3.7.16

For what it's worth, I thought I'd forward the spelling errors reported by qt-project's automatic review system. The ones with the asterisk depend on which national spelling standard you follow. src/3rdparty/sqlite/sqlite3.c: sytem -> system (occurs twice) existance -> existence

[sqlite] How to install sqlite 3.7.11

Hello all, I want to install sqlite 3.7.11 in my ubuntu 10.04. Got the source code but no the makefile/config file. >From where can ,I Download the set-up and how to install it. Please reply soon. Thanks in advance. Regards Pratik Patodi

[sqlite] atof1 and sysfault test failures

I am having below test failures on ARM board with linux atof1.test: -- Expected: [1] Got: [0] atof1-1.1520.1... Ok atof1-1.1520.2... Ok atof1-1.1521.1...{3bf01ed5b1b47f07 3bf01ed5b1b47f06} 5.461820304745700866657409448094520528310601164636732323884316e-20

Re: [sqlite] How to install sqlite 3.7.11

On 21 Mar 2013, at 4:43am, Pratik Patodi wrote: > I want to install sqlite 3.7.11 in my ubuntu 10.04. > Got the source code but no the makefile/config file. > > From where can ,I Download the set-up and how to install it. SQLite is not something you install into

Re: [sqlite] How to install sqlite 3.7.11

Simon Slavin wrote: > On 21 Mar 2013, at 4:43am, Pratik Patodi wrote: >> I want to install sqlite 3.7.11 in my ubuntu 10.04. >> Got the source code but no the makefile/config file. > > SQLite is not something you install into your computer, where it is > then used by

Re: [sqlite] How to install sqlite 3.7.11

On 21/03/2013 11:47 AM, Simon Slavin wrote: On 21 Mar 2013, at 4:43am, Pratik Patodi wrote: I want to install sqlite 3.7.11 in my ubuntu 10.04. Got the source code but no the makefile/config file. From where can ,I Download the set-up and how to install it.

[sqlite] Problem getting utf-8 text out of a text column

I have a column defined as TEXT and I insert utf-8 text into it. In particular, there are byte sequences that might look as follows: ... 74 6F 20 C2 A3 32 35 30 ... (in hex) which represents: ... to £250 ... I used Navicat for SQLite Lite to peer at the data as hex and text in the column, and it

Re: [sqlite] Problem getting utf-8 text out of a text column

On 21 Mar 2013, at 10:52pm, Tim Streater wrote: > I have a column defined as TEXT and I insert utf-8 text into it. In > particular, there are byte sequences that might look as follows: > ... 74 6F 20 C2 A3 32 35 30 ... (in hex) > which represents: > ... to £250 ... > I

Re: [sqlite] Problem getting utf-8 text out of a text column

Simon, Thanks for the suggestions. I should have mentioned that I'm running under OS X so I have the sqlite3 application and can easily do the tests you suggest. But that'll have to be tomorrow - time for shuteye now :-) Cheers -- tim ___

Re: [sqlite] Problem getting utf-8 text out of a text column

On Thu, Mar 21, 2013 at 6:52 PM, Tim Streater wrote: > I have a column defined as TEXT and I insert utf-8 text into it. In > particular, there are byte sequences that might look as follows: > ... 74 6F 20 C2 A3 32 35 30 ... (in hex) > which represents: > ... to £250 ... >