Displaying 1 result from an estimated 1 matches for "timetoken".
2011 May 25
1
Time and db precision
I have a loop that regularly checks for new data to analyse in my database. In order to facilitate this, the database table has a timestamp column with the time that the data was inserted into the database. Something like this:
while (....) {
load(timetoken.Rdata)
df <- sqlQuery(con, paste("SELECT * FROM tabledf WHERE timestamp > ", timetoken, sep = ""))
analyse(df)
timetoken <- max(df$timestamp)
save(timetoken, file = "timetoken.Rdata")
Sys.sleep(60)
}
Now this used to work fairly well with...