2006/2/9, Jose Antonio <[EMAIL PROTECTED]>: > 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?
a smallint column should be acceptable for storing millisecond (that's what we use), but depending on the way you need to manipulate those millisecond, a tinyint could be acceptable as well (you only store millisecond with a precision of 1/8 second). -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]