Re: The Incredible Expanding Database

Scott Lagos ( )
Sun, 28 Jun 1998 16:32:57 -0400

Part of the problem in Access with at least RADIUS version 2.2, and this
may be the same for 2.5, is that each time a query is called from the mdb
it is compiled and it takes up space within the database - this space can
only be recovered with a compact.

I know that 2.2 calls the CallsOnLine query directly instead of pulling the
query externally with a SQL statement refering to the required tabled. I
suspect, but I'm not certain, that this is the cause of the bloating.

There are a few articles on MS Support that descrive about 10 different
ways that bloating occurs.

At 09:05 AM 6/26/98 -0700, you wrote:
>Hi, we are using RadiusNT to authenticate against an MSAccess database. I
>have noticed that after about 24hours of running this database has grown
>from about 7MB to over 100MB in size. I have needed to stop the RadiusNT
>service (not good) and compact/repair the database to return it to a more
>manageable size.
>Anybody have an idea what I am doing wrong?