使用Compact和Repair消失的后端数据库膨胀 [英] Backend database bloat that vanishes with Compact and Repair

问题描述

我的客户端MS Access 2010后端数据库每天早上压缩到32 MB，但在一天的使用期间膨胀到600 MB以上。这位工作人员表示，大约4个月前才开始这样做。那是在我参与扩展数据库的时候，他们从Access 2007升级到2010年的
我们将前端从后端拆分（但她说在分裂之前开始了"膨胀"。）去年，他们每天早上从主Oracle数据库导入数据，并运行更新查询到
更新他们的数据。每天早上实际添加的数据并不多（使用一年后数据库只有32 MG），主要是将辅助Access数据库与主Oracle数据库同步。但我认为他们这样做的方式没有任何
的重大变化，这可能导致了膨胀，我们在运行更新后看不到文件大小的任何显着增加。日常使用也增加了非常少的数据，但该文件似乎在白天膨胀。我一直在做的工作是使用VBA进行前端自动化电子邮件发送，我们仍在进行原型测试，所以我不认为它会影响后端大小。每次运行Compact和Repair时，数据库都会返回大约32 MB。有没有人有
任何想法可能导致这种临时膨胀在压实时消失？我不知道从哪里开始寻找。

My client's MS Access 2010 backend database compacts to 32 MB every morning but swells to 600+ MB during a day's use. The staff programmer says it only started doing this about 4 months ago. That was around the time I got involved extending the database, they upgraded from Access 2007 to 2010 and we split the front-end from the back-end (but she says the "bloat" began before the split.) For the last year they have been importing data from their main Oracle database each morning and running update queries to update their data. There isn't very much data actually added each morning (the db is only 32 MG after a year of use) it's mostly a matter of synchronizing their auxiliary Access database with the main Oracle database. But I don't think there have been any major changes to the way they do this that could account for the bloat and we don't see any significant increase in the file size after running the updates. Daily use also adds very little data, but the file seems to swell during the day anyways. The work I've been doing is in the front-end automating email sending with VBA and we're still in prototype testing so I wouldn't think it would affect the back-end size. And the database returns to about 32 MB each time we run Compact and Repair. Does anyone have any idea what could be causing this temporary bloat that vanishes on compaction? I'm at a loss to know where to begin looking.

谢谢，

Tim Mixon

Tim Mixon

Tim Mixon

Tim Mixon

推荐答案

您是否仍在BE中进行任何剩余处理？

Do you have any residual processing still being done in the BE?

例如与Oracle数据库同步...如何完成此过程？

E.g. synchronising with the Oracle database... How is this process being done?

这篇关于使用Compact和Repair消失的后端数据库膨胀的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！