On Wednesday, Oct 26, 2011 at 02:26PM Jay A. Kreibich wrote: > On Tue, Oct 25, 2011 at 11:51:46PM +0200, Tobias Mohrlüder scratched on the > wall: >> Hello everybody, >> >> I strongly believe that my setup is somehow wrong, I just can't figure >> out how. > > >> sqlite3_prepare_v2(db, "SELECT * FROM mytable WHERE MyKey IS ?", -1, &stmt, >> 0); > > Don't use "IS", use "=". The two operations are quite different. > > -j
That's it, thanks! I'm still wondering why there is such a huge performance hit. Judging from the documentation I would have expected some if-statements worth of overhead, nothing serious. Regards, Tobias _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users