Reduce the size of the Audit file other than delete the whole Audit History
The audit history has skyrocketed and the size of the Audit.sqlite file is more than 1GB.
The performance becomes poor.
And despite the audit history is set to be 365 days, the aged audit history is not removed.
Currently, the only way is to delete the audit history for the whole cube.
Would be good to have the functionality to remove aged records.
ADMIN RESPONSE
Nov 20, 2023
Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog. If you can add further information about the context of this feature, please add it here so we can evaluate it more fully.
Instead of using SQLite, could Jedox consider using PostgreSQL? Jedox already uses it for Drill through, I believe. This should bring better performance, especially if indexing tasks are implemented.
The main issue here is the performance. It should be possible to delete the audit before Time X, but it should also be possible to view the data without crashing the server!!
Instead of using SQLite, could Jedox consider using PostgreSQL? Jedox already uses it for Drill through, I believe. This should bring better performance, especially if indexing tasks are implemented.
The main issue here is the performance. It should be possible to delete the audit before Time X, but it should also be possible to view the data without crashing the server!!