top | item 25344830

(no title)

actionowl | 5 years ago

Just one data point, that might be of use to know:

We're currently running into an issue where we've used a table as a message queue in a database.

We gained a compliance requirement that we must log all access (including direct DB queries) to certain info in the database. One of the tables being used as a queue contains this data and is polled hundreds of times per minute making our logs ridiculously huge and we now have to move the queue somewhere else and/or split up the data.

discuss

order

popinman322|5 years ago

Surely moving the data doesn't change the compliance requirement?

actionowl|5 years ago

No, but in our case, moving the sensitive data to a table queried less frequently than one used as a queue shrinks our logs considerably.