开发者

Having problem with Timestamp

Scenario: Two tables (table1, table2) with this开发者_如何学JAVA format: id:short; timestamp:short; price:single

The data in both table are thesame except the timestamp. Timestamp is given as a unix_time in ms.

Question: What is minimum time difference between the timestamps of same record in table1 and table2.


In theory, the minimum time difference would be 0 or even 1ms. In practice wouldn't the time difference be a function of what it takes to put the data into the table along with other external performance factors?

One question I would have about the tables is why is the same record being stored in two places?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜