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