Displaying 1 result from an estimated 1 matches for "lastbreak".
Did you mean:
last_read
2005 Nov 17
1
Histogram over a Large Data Set (DB): How?
...o limit data set size, as described below.
spams <- dbGetQuery(con, "select unixtime from email where LENGTH(email_to)=4")
firstspam <- min(spams$unixtime)
lastspam <- max(spams$unixtime)
# spansize == one day
spansize <- 60 * 60 * 24
firstbreak = floor(firstspam / spansize)
lastbreak = celing(lastspam / spansize)
spambreaks = (firstbreak:lastbreak) * spansize
hist(spams$unixtime, br=spambreaks, plot=TRUE, col="red")
-----
The "where" clause serves to limit the number of records, while I figure out
the surrounding parts. And now I'd like to do that......