Complex datatypes in Django

Ana Willem — Thu, 02 Jun 2022 03:59:05 +0000

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.

DEV Community: Ana Willem

Complex datatypes in Django