还有另一个后端膨胀讨论 [英] Yet another Backend Bloat Discussion

问题描述

在我加入

公司之前，我正在使用已经存在多年的后端。它有点成倍增长并且有一些设计问题

包括大量未使用的表，一些临时表。它压缩到了150亿美元，但是在一天之后它就达到了300Mb，并且它从那里开始稳定地从

开始。我需要：

（a）减小尺寸

（b）减少膨胀系数


除了移动临时表到前端（不能
可能占所有这个膨胀）和清空/删除

未使用的表是否有人有任何有用的建议？任何好的

在线指导后端臃肿等常见原因？


此外，如果有人有任何VB功能或查询分析所有

表统计 - 大小，用法等非常有帮助。


万分感谢


比尔

I''m using a backend that''s been around for years before I joined the
company. It kind of grew exponentially and has some design problems
including large unused tables some temporary tables. It compacts to
150Mb, but after a day it''s up to 300Mb and it gros steadily from
there. I need to:
(a) reduce the size
(b) reduce the bloat factor

Apart from moving the temporary tables to front end (which can''t
possibly account for all of the this bloat) and emptying/deleting
unused tables does anybody have any helpful suggestions? Any good
online guides to common causes of backend bloat etc?

Also if anyone has any VB functions or queries for analysing all the
table stats - size, usage etc that would be very helpful.

Thanks a million

Bill

推荐答案

我在多用户
环境中访问的最佳链接和信息集合是MVP Tony Toews 'site
http://www.granite.ab.ca/ accsmstr.htm 。


前端或后端的临时表会导致膨胀，但

有一个简单的答案那个问题...创建一个临时数据库，创建

该数据库中的临时表，链接到它，使用它，取消链接，并使用

Kill语句删除临时数据库。我相信Tony有一个

的例子。


所有Access数据库都受到增长的影响。 - 已删除的空间

记录和已删除的对象未恢复;它只是呆在那里，直到你在数据库上做一个Compact。


Larry Linson

Microsoft Access MVP


" BillCo" <共********** @ gmail.com>在消息中写道

news：11 ********************* @ g49g2000cwa.googlegro ups.com ...

The best collection of links and information on Access in a multiuser
environment that I have found is at MVP Tony Toews'' site
http://www.granite.ab.ca/accsmstr.htm.

Temporary tables in either your front- or back-end will cause bloat, but
there is an easy answer to that issue... create a temporary database, create
the temporary table in that database, link to it, use it, unlink, and use
the Kill statement to delete the temporary database. I believe Tony has an
example of that.

All Access databases are subject to "growing" -- space occupied by deleted
records and deleted objects is not recovered; it just stays there until you
do a Compact on the database.

Larry Linson
Microsoft Access MVP

"BillCo" <co**********@gmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

在使用
公司之前，我正在使用已经存在多年的后端。它呈指数级增长，并且存在一些设计问题，包括大量未使用的表，一些临时表。它紧凑到150Mb，但是一天之后它就达到了300Mb并且它在那里稳定地从那里开始。我需要：
（a）减小尺寸
（b）减少膨胀因素

除了将临时桌移动到前端（不能
可能占所有这个膨胀）和清空/删除
未使用的表是否有人有任何有用的建议？有关后端膨胀的常见原因的任何好的在线指南等吗？

如果有人有任何VB功能或查询分析所有的表统计 - 大小，用法等非常有帮助。

感谢一百万比尔

I''m using a backend that''s been around for years before I joined the
company. It kind of grew exponentially and has some design problems
including large unused tables some temporary tables. It compacts to
150Mb, but after a day it''s up to 300Mb and it gros steadily from
there. I need to:
(a) reduce the size
(b) reduce the bloat factor

Apart from moving the temporary tables to front end (which can''t
possibly account for all of the this bloat) and emptying/deleting
unused tables does anybody have any helpful suggestions? Any good
online guides to common causes of backend bloat etc?

Also if anyone has any VB functions or queries for analysing all the
table stats - size, usage etc that would be very helpful.

Thanks a million

Bill

" Larry Linson" <博***** @ localhost.not>写在

news：Wnjxe.5278

"Larry Linson" <bo*****@localhost.not> wrote in
news:Wnjxe.5278

mr4.693@trnddc05：

mr4.693@trnddc05:

前面的临时表 - 或者后端会导致膨胀，但是这个问题有一个简单的答案...创建一个临时数据库，在该数据库中创建临时表，
链接到它，使用它，取消链接，并使用Kill语句删除临时数据库。我相信Tony有一个例子。

Temporary tables in either your front- or back-end will cause
bloat, but there is an easy answer to that issue... create a
temporary database, create the temporary table in that database,
link to it, use it, unlink, and use the Kill statement to delete
the temporary database. I believe Tony has an example of that.

让我投票*不*杀死创建的临时MDB - 只需重复使用

。


如果你担心臃肿，那么从服务器上取下一个空的副本来取代二手。复制。


我曾经在退出时删除temp.mdb并在应用程序加载时从空的

膨胀对今天的工作站来说不是问题，工作站有10英镑的b $ b GB的可用磁盘空间。


-

David W. Fenton http：/ /www.bway.net/~dfenton

dfenton at bway dot net http://www.bway.net/~dfassoc

这篇关于还有另一个后端膨胀讨论的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！