The purpose of my application is to retrieve records based on a criteria.

The problem is that there could be millions of records but I only want to select records that were updated in the last 1 minute.

First time I select all records but after a minute I cannot select everything again as it would take a very long time. I only want to select Orders that were updated within that interval.

```
var records = context.Orders.Where(x => x.Category == "GAMING");

```

Is there something I could do? Subscribe to some sort of database event?