Sure (com certeza!), because it depends on the hardware and software of your target platform.
2010/2/10 Alberto Simões <hashas...@gmail.com> > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
