Hi,
Sippy currently continuously runs SQLs to detect changes in tables to update caches. I think this can be better not to overload database.
What I offer here is, to subscribe to PostgreSQL NOTIFY events and do an update when an NOTIFY event is triggered.
An example for `Twisted` framework is at: HOWTO: Automatically Responding To PostgreSQL Table Changes With Twisted
Regards,
Erkan Durmus
Eurotel AS - www.eurotel.com.tr
Erkan Durmuş
Hi,
Sippy currently continuously runs SQLs to detect changes in tables to update caches. I think this can be better not to overload database.
What I offer here is, to subscribe to PostgreSQL NOTIFY events and do an update when an NOTIFY event is triggered.
An example for `Twisted` framework is at: HOWTO: Automatically Responding To PostgreSQL Table Changes With Twisted
Regards,
Erkan Durmus
Eurotel AS - www.eurotel.com.tr