An efficient way to store time is as UNIX_TIMESTAMP (4 bytes) instead of using DATETIME data type (8 bytes). We were using this technique to save the time in our database.
Now we need to support millisecond resolution as we need to store data comming 8 times per second, that is, every 125 milliseconds. Have you already face this problem and come to a solution you are happy with? Thank you for taking the time to read this email & for your support. José Antonio