Hi, I am gonna try first creating unique index (hid, pid). It will take a bit of time and will keep you posted with the result.
Thanks a lot Gaurav On Thu, Nov 24, 2011 at 2:08 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > -- Gaurav Vyas Graduate Research Assistant, Transportation Engineering University of Texas at Austin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
