I have a very simple table:
CREATE TABLE Log (
LogDate,
LogText
);
Just when did the event happen, and what was it. So now I'm populating the
fields and I'm trying to decide whether LogDate should be in unixtime
format, or raw date format ('2008-01-01 13:12:11').
I'm assuming unixtime would store as less bytes? Are there any inherent
speed advantages either way? Do the date functions work faster on either one?
--
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
