Re: [sqlite] Indexes not being used after INNER JOINS?

.DLL ;-) b) It must have bindings with .Net 2.0 and Mono >1.2.5. c) Open-Source. Switching to a client-server application like PostgreSQL that can't be embedded into the application would actually be my last resort. Cheers and thanks! Hugo Ferreira On Dec 31, 2007 11:56 PM, Scott Baker <

Re: [sqlite] Indexes not being used after INNER JOINS?

know what it is :P There must be something very strange going on... I suppose it is not possible to create indexes on views, right? I'll play some more with queries and try to figure out if I can tweak this. If not, then I guess I'll unfortunately have to move to PostgreSQL :-( Cheers! Hugo Ferreira

[sqlite] Indexes not being used after INNER JOINS?

idx_data_reftemporal_id ON data(reftemporal_id) CREATE INDEX idx_esparqueologico_datacao_id ON esparqueologico(datacao_id) Cheers, Hugo Ferreira

Re: [sqlite] Re: Update on Insert

sends SQL: INSERT INTO X(c1, c3) VALUES(1, null) Should be translated to: Replace column c3 to null and leave c2 alone. In other words, it should function like the PRIMARY KEY c1 ON CONFLICT REPLACE, but it should replace ONLY the columns that are actually expressed in the statement, not the f

[sqlite] Update on Insert

ERT INTO X (c1, c2, c3) VALUES(1, null, 'a') --> UPDATE X set c2 = null, c3 = 'a' WHERE c1 = 1 INSERT INTO X (c1, c3) VALUES(1, 'a') --> UPDATE X set c3 = 'a' WHERE c1 = 1 Thanks for any help/ideas you may have! Cheers! Hugo Ferreira -- スプーンが ない