On Thu, Nov 19, 2015 at 11:26 AM, Simon Slavin <slavins at bigfraud.org> wrote:
> > On 19 Nov 2015, at 4:06pm, Andrew Stewart <AStewart at arguscontrols.com> > wrote: > > > Would storing the dateTime as Integer make the database and > indexes smaller? > > Yes. An integer will take a maximum of 8 bytes to store. A string's > storage needs at least one byte per character in the string. And the > format you're using for date/time stamps is longer than 8 characters long. > To be pedantic, an integer can take up to 9 bytes. https://www.sqlite.org/fileformat.html#varint Eric