> SS> Is there a difference between a key being present in your database with > NULL value, and the key not being present ? > Surely there is. But, actually, those 10000 queries are made only to keys > with a non-NULL value (usually less than 1 Kb, and maybe 20% are about 16 > kb).
*Probably* not related to your performance concerns (since as you say, searching for the key doesn't look to be your issue), but for this case you may consider a partial index https://www.sqlite.org/partialindex.html to reduce the number of seeks a little bit by reducing the depth of the index tree.
signature.asc
Description: Message signed with OpenPGP using GPGMail
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
