backend compacting

[Russ]

I've got my db split into front and backends. When the option of
compressing the database upon closing is selected does the backend get
compressed or does the front end get compressed? The front end
normally gets no changes so I think compression will not help, but the
backend is another story.

Russ

 

[Dirk Goldgar]

I've got my db split into front and backends. When the option of
compressing the database upon closing is selected does the backend get
compressed or does the front end get compressed? The front end
normally gets no changes so I think compression will not help, but the
backend is another story.

Only the front-end is compacted by the Compact On Close option.
Compacting that may help some; it depends on what you're doing. As for
the back-end, you must either periodically compact it manually, or set
up an automated process to do it. Naturally, you can only do it when no
one else is in the database.