reanahub / reana-job-controller

REANA Job Controller
http://reana-job-controller.readthedocs.io/
MIT License
2 stars 38 forks source link

in-memory database: refactor needed #424

Open mdonadoni opened 10 months ago

mdonadoni commented 10 months ago

Job controller is keeping an "in-memory" copy of the Job table of the database.

First of all, we should investigate why this is needed, maybe for performance reason?

If it's not needed, should we drop the in-memory database and only use PostgreSQL?

If the in-memory database needs to be kept around, then:

mdonadoni commented 1 week ago

After the recent performance profiling and improvements, I think this was done for performance reasons to avoid accessing the database to know the current status of jobs. Note that writes are always done also on the database, so there is no performance gain there