2

I have a process that generates a new record every 10 minutes. It was great for some time, however, now Datum.all returns 30k+ records, which are unnecessary as the purpose is simply to display them on a chart.

So as a simple solution, I'd like to provide all available data generated in the past 24 hours, but low res data (every 100th record) prior to the last 24 hours (right back to the beginning of the dataset).

I suspect the solution is some combination of this answer which selects every nth record (but was provided in 2010), and this answer which combines two ActiveRecord objects

But I cannot work out how to get a working implementation that obtains all the required data into one instance variable

stevec
  • 41,291
  • 27
  • 223
  • 311

1 Answers1

2

You can use OR query:

Datum.where("created_at>?", 1.day.ago).or(Datum.where("id%100=0"))
Vasfed
  • 18,013
  • 10
  • 47
  • 53