Page 1 of 1

PT3 DB size is >>>>>> PT2

PostPosted: Tue May 27, 2008 11:32 am
by admiralfluff
Is this normal? After converting a PT3 DB, it's around 10x bigger than the corresponding PT2 DB file. I have both storing HHs.

Re: PT3 DB size is >>>>>> PT2

PostPosted: Tue May 27, 2008 3:17 pm
by kraada
Yes, the PT3 database saves a LOT more data than the PT2 database. As a result, it is much larger.

Re: PT3 DB size is >>>>>> PT2

PostPosted: Tue May 27, 2008 10:23 pm
by admiralfluff
I wasn't expecting a 4M hand DB to be over 33GB when it was like 2.5GB with PT2. Is there, could there, be any way to streamline this? Can I delete variables or columns from the SQL structure to save size without totally boning everything?

Re: PT3 DB size is >>>>>> PT2

PostPosted: Wed May 28, 2008 5:17 am
by WhiteRider
No, I doubt it, unless you REALLY understand the structure of the complex PT3 schema.
You will almost certainly break something.

Re: PT3 DB size is >>>>>> PT2

PostPosted: Thu May 29, 2008 9:16 am
by Josh
Make sure you vacuum your database, as that may dramatically decrease the size.

highfalutin