At the moment we don't have any indexing set up for this. My guess is that we should at a minimum be indexing by productName, category, and store.
We might want a store : location combined index as well?
Might want a range index on the pantry items expiry dates.
I'm not sure how to ensure that the indices are present on both development DBs (including GitHub Actions) and on the production DB. Maybe we need a script for that?
At the moment we don't have any indexing set up for this. My guess is that we should at a minimum be indexing by
productName,category, andstore.We might want a
store : locationcombined index as well?Might want a range index on the pantry items expiry dates.
I'm not sure how to ensure that the indices are present on both development DBs (including GitHub Actions) and on the production DB. Maybe we need a script for that?