On Wed, Feb 10, 2010 at 5:42 PM, Virgilio Fornazin <virgilioforna...@gmail.com> wrote: > 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).
Yes, I know it should be faster.. I just would like to have an idea of how fast to know how relevant is an indirection table (from string to integer). But probably the best is to try and compare :P > > 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 > -- Alberto Simões _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
