Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread DAT file seems rather large.
Fri, Aug 31 2007 12:45 AMPermanent Link

P.Read
Hi,

I have a historic transaction table containing 29 fields. Now looking at some clients data
of this table, they have 52,802 records which is fine, but the filesize of this tables
.DAT file is 31.4MB before and after optimisation. Does this sound correct? Just sounds
quite big to me.

Thanks,

Phil.
Fri, Aug 31 2007 1:57 AMPermanent Link

"Uffe Kousgaard"
That's an average of 20 bytes per field. If you have many char fields it
sounds OK.


"P.Read" <phil@vizualweb.com> wrote in message
news:DFA9210B-CC62-4627-AD32-D1D8FDB103C2@news.elevatesoft.com...
> Hi,
>
> I have a historic transaction table containing 29 fields. Now looking at
> some clients data
> of this table, they have 52,802 records which is fine, but the filesize of
> this tables
> DAT file is 31.4MB before and after optimisation. Does this sound correct?
> Just sounds
> quite big to me.
>
> Thanks,
>
> Phil.
>

Fri, Aug 31 2007 2:48 AMPermanent Link

Phil Read
Thanks Uffe, I just wanted someones opinion and doing math, your right,
that's pretty good, plus the backup file is so well compressed there's
no issue at all,

Cheers,

Phil.
Image