I think you should be asking 'How fast is SQLite locating a key in a integer column index vs a string index'...
Generally, integer keys are faster in key lookups than string keys, because comparing a integer value is a single CMP CPU instruction versus a more-complicated string comparison (that can be virtually unlimited in size). On Wed, Feb 10, 2010 at 15:38, Simon Slavin <slav...@bigfraud.org> wrote: > > On 10 Feb 2010, at 5:19pm, Alberto Simões wrote: > > > I know I can benchmark myself this question, but I am sure somebody > > did that already. > > > > Supose a table with a key that is a string (say, words from 1 to 10 > > characters) or a table with a key of integers. > > > > How different is the efficiency on fetching one record on these tables? > > How are you fetching the record ? Do you have a SELECT command that looks > up the record using a WHERE clause matching a key value ? Is there an index > on the key column ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
