Konstantinos Alogariastos schrieb am 17.05.2013 17:41:
... class can have only 5 distinct values, while Id will
reach to the millions ...
Kostas,
in this case looking up by "class" first would mean to scan through
2/5th of your data (assuming even distribution). So how long is that
"long list of integers"? Does it reference 40% of your data? If not,
you're better off with looking up by "id" anyway. Try for yourself.
regards
Gerd
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
