On 24 Nov 2011, at 7:54am, Gaurav Vyas wrote: > when I do typeof(hid), it gives "real".
You might look into why it is not storing integers instead. It is faster to search integers than it is to search real numbers. The hid column in your table should probably be defined with a type of INTEGER. <http://www.sqlite.org/datatype3.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users