What is the proper size of a sqlite database of 4 primary keys if I need fast query speed? -


i have sqlite database map storage. table this:

(x,y,zoom,type,image)  

where

(x,y,zoom,type) 

is combined primary key. know max size(rows) database if query 1 image query time less 100ms. working on intel i5 modern laptop.


Comments