On 13 Dec 2011, at 5:38pm, jr wrote: > since much of that time will be spent in the strftime() calls and > calculations, how about adding a lookup table with pre-computed date/times?
Actually, with this much use of the date/time information I'd be storing it all as numbers. And if you're wedded to the 5 minute period you might even want to create a column specifically for which 5 minute period the time/date falls in. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
