I have to show which doors in a building people can open with their keys. There are 4 tables I have to get through to do it. The ORM is just not cutting through it (or it does but it takes a minute for some folks with master keys to load all of the doors).
So my options are:
- Create calls to StoredProcedures and let the DB engine do it's thing faster.
- Create database views and let the DB do it's thing faster.
- Other ideas?
We already have and use Triggers, StoredProcedures and Views in the database, so there is no prescient precedence to do things any particular way.
Top comments (0)