Hi all,
I am facing an interesting optimization problem.
I have a table like this:
CREATE TABLE ranges (
start int,
end int,
value int,
);
The query that I am interested in optimizing is "select value from ranges
where (? between start and end)"
The max performance that I was able to get is 250 results/second with a
covering index on all three columns.
Now, if I do a more classic "select value from ranges where start = ?" this
provides 140000 results/second
So I am pretty sure that I am doing something quite wrong.
Do you guys have any idea of what it could be? How can I obtain better
results?
Cheers,
Simone
--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
