I have a rails app querying a MS SQL DB, it is checking to see if one column is false, but I realistically only need to check in the last 1000 records (there are just over 900,000 records).
It takes a long time to check over everything every time, so is there a way to limit it to only check the last 1000 for this column? I've tried using @object.find_each, but that checks 1000 at a time, but goes through the whole table.