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. Simon.