Hi, I have been using SQLite for a while now and I have been getting very good
performance. However, recently I have been stumped by the poor performance of a
particular query. I wonder if anyone out there can shed any light on the matter
for me.
I have a database with a number of tables (N) wi
Hi,
I have a COM component to which sqlite++ library was added, now I want to
improve caching of queries.
It's already working speeding up nicely by caching each query, but it uses a
setting for how many queries to cache and for how long.
I believe in automating everything that's possible, so
I am sorry, I should have made some clarifications about the way the wrapper is
implemented, let me answer your concerns.
I see many problems here:
* It fails if your update or delete from a different
database connection or a different process such
that the update or delete is not
Are you wanting something like this:
INSERT INTO 'mytable' (key, 'visitorcount', 'visitdate')
VALUES (123456789, 1, NOW())
ON DUPLICATE KEY UPDATE 'visitorcount' = 'visitorcount' + 1
the key statement being: ON DUPLICATE KEY UPDATE
not tested but it seems like that is what you are looking for.
Geez. I am sorry. You are correct. This is MySQL. Sorry about
that and to the OP. (banging forehead with open faced palm of my
hand!!!)
Tony
On Sun, Sep 13, 2009 at 6:56 PM, Jean-Christophe Deschamps
wrote:
>
>
> ´¯¯¯
>>INSERT INTO 'mytable' (key, 'visitorcount', 'visitdate')
>>VALUES (12
I see this:
CREATE TABLE table1( id INTEGER PRIMARY KEY ON CONFLICT REPLACE, field1 TEXT
);
but I think that the table has to already have been created this way.
I found that in the docs: http://sqlite.org/lang_conflict.html
Would that help the OP?
On Sun, Sep 13, 2009 at 6:56 PM, Jean-Christ
6 matches
Mail list logo
