Fast lookup of bulky "table"

[Greg Ewing]

On 16/01/23 2:27 am, Dino wrote:
> Do you have any idea about the speed of a SELECT query against a 100k 
> rows / 300 Mb Sqlite db?

That depends entirely on the nature of the query and how the
data is indexed. If it's indexed in a way that allows sqlite to
home in directly on the wanted data, it will be very fast. If
it has to fall back on a linear search, it probably won't be
significantly faster than your existing Python implementation.

-- 
Greg