MDW Bloat?

[Brian]

Hi,
Can someone tell me what the MDW file actually does?
I have a FE/BE app and my own MDW file and I notice that at some of my
clients it rapidly grows to 10-15MB. I can compact it to 150KB but it just
grows again. There would be about 10-15 people using my app concurrently.

Thanks
Brian

 

[Joan Wild]

I wouldn't worry about it. The mdw is just another mdb - it will bloat like
any other mdb.

 

[Brian]

Ms Wild,
The app does startup faster after it's compacted. The mdb does not bloat
anywhere as much. What goes into the mdw other than the username and
password? Anything that I might be doing in my app that makes it bloat?
Regards
Brian

 

[Joan Wild]

Ms Wild,
The app does startup faster after it's compacted. The mdb does not
bloat anywhere as much. What goes into the mdw other than the
username and password? Anything that I might be doing in my app that
makes it bloat?

I don't believe so. I found that it would bloat to a certain size, and then
stay at that size.

Just compact it periodically.

 

[TC]

Presumeably you are not creating or deleting users or groups through
code (createuser etc.) ?

TC

 

[Brian]

I do but it would have been before the compact and rebloat.
Brian