开发者

Having problem with Timestamp

开发者 https://www.devze.com 2023-03-16 07:20 出处:网络
Scenario: Two tables (table1, table2) with this开发者_如何学JAVA format: id:short; timestamp:short; price:single

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

精彩评论

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