frequent compacting messages

[pto432]

Hello,

I'm running PTO 1.13.01b and the database (access) I'm currently using is for all hands I've played in 2008. There are about 40K hands and I frequently get the message that the hand and poker database should be compacted. It's started to get kind of annoying because this message comes up every few days. I'm wondering if for 2009 whether I should create a new database for each month to prevent this?

Secondly, I tried creating a postgres database because I thought this might be more efficient than access, but the dropdown in "ODBC Entry to Use" is blank. I have both Postgres 8.2 and 8.3 installed and read a thread that 8.2 works, but 8.3 does not. If so, what do I need to do to enable Postgres in PTO and more importantly, would this help prevent the necessity for frequent database compacting?

Thanks for your help!

[ptrack mike]

First, get this patch - it has some important fixes in it:
viewtopic.php?f=34&t=14249

On the menu, open Utilities > Compact Database Preferences... and change the value to 0 and you won't get nagged anymore. Just remember to compact every so often.

If you installed PostgreSQL 8.2 then the ODBC dropdown should now have values. See the 4th post of this thread:
viewtopic.php?f=29&t=5669&st=0&sk=t&sd=a&hilit=ODBC+Entry+to+Use+blank

[pto432]

Thanks for that info Mike.

Is Postgres the better database to use, or is doesn't matter too much?

[ptrack mike]

It really only matters if your database is getting huge and you don't want to manage multiple Access databases.