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

2013-03-21 Thread Clemens Ladisch 
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.  ;-)


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2013-03-21 Thread Frank Chang 
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
FREQMARY ), 1), 14)?
Thank you for your help.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users