2011/8/11 Sumit Gupta <[email protected]>: > 10-10-2011 18:48:42, 10,20, 30, 40, 50, 60, 80 .. <48 such entries>
Use unixtime (time in seconds) and index on this field and your queries will be fast. You can use single blob as integers array for more compact database. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
