On 18 Mar 2011, at 6:51am, Michael Parker wrote: >> http://www.sqlite.org/datatype3.html > > Ahh, interesting. Since the date granularity is days and does't > include the time, I'll be changing date and uid to use REAL and TEXT, > respectively.
INTEGER and TEXT ? Or did I misunderstand you. REAL will be faster than TEXT, and INTEGER will be faster than REAL, I think. Good luck with it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users