JBoss 环境和巨大的审计表
我正在使用 JBoss Evers 审计我的 Java EE 应用程序,我的应用程序的性质导致审计表增长得非常快。除了上周的数据外,历史数据很少被查询,访问时间也不是真正的问题。该数据被频繁查询并且访问需要快速。理想情况下,我将拆分数据并将其分布在两个表中,其中旧数据采用压缩格式。
不幸的是,据我从文档中得知,Envers 不允许将数据分布在多个表上。
有人知道实现这一目标的最佳方法是什么(如果可能的话,同时仍然使用 Envers)?
I am auditing my Java EE application with JBoss Evers and the nature of my application causes the audit table to grow very fast. The historic data is queried infrequently and access time is not really an issue, apart from the data from the last week. This data IS queried frequently and access needs to be fast. Ideally, I would split the data and distribute it over two tables, with the older data in compressed format.
Unfortunately, Envers does not allow spreading data over multiple tables as far as I can tell from the docs.
Does somebody have any idea what would be the best way to achieve this (if possible while still using Envers)?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
StackOverflow 第一次不知道问题的答案!
我在 JBoss 论坛上发布了同样的问题,Adam 的回答非常有帮助:
您好,
不确定您使用的是哪个版本的 Envers,但也许您可以尝试使用 ValidityAuditStrategy(从 3.6 开始)。
另请参阅:http://opensource.atlassian.com/projects/hibernate/browse /HHH-5371
Adam
论坛条目反向链接:http://community.jboss.org/消息/579047
For the first time, StackOverflow does not know the answer to a question!
I posted the same question in the JBoss forum and Adam's answer was very helpful:
Hello,
not sure which version of Envers you are using, but maybe you can try using the ValidityAuditStrategy (present from 3.6).
Also, see: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5371
Adam
Backlink to the forum entry: http://community.jboss.org/message/579047