At 5/13/2003 12:03 PM (Tuesday), jbgilmartin wrote:

>It is not just 800 objects, but 300 to 1500 per day. With Access'
>storage methodology, one day's worth of log processing makes the DB
>grow by an order of magnitude.

But 1500 objects times 1500 bytes each per log record is only 2.5MB per day
growth. That's 800MB per year, which I find entirely manageable and not all
that large. Perhaps with Access it is a problem but not with Firebird!

> From what I understood varchars are not compressed on the data page,
>they are stored full length in the record plus a two byte length
>indicator, thus there would be "empty" space at the each of each line
>up to the size of the varchar field. Am I wrong?

I think that is wrong. They are compressed along with the entire record
(run length encoding method).