Played Hands vs. Observed Hands Databases

[ORAG]

In the Auto Import I see where you can choose to place observed hands in another database. Is this available somewhere when importing manually? Also, what is the specific advantages to this?

Regarding the database, is it normal for my 2 GBs of HHs to have a database >12GB? Everything seems very slow when doing things within PT3, do I just have too many hands to have any speed?

[Josh]

There's no way to use separate databases when using manual import. The advantages to having it during auto-import is for datamining. The Hud will eventually be able to read data from multiple databases. You keep your played hands in one database, and you can keep your observed hands in separate, rotating databases (start a new one every month, delete the oldest one).

I don't know how many hands you have, but about 5-6 GB per million hands, I believe, is about how much room it takes. Have you vacuumed and/or clustered your database recently? Not doing that every 50-100k hands will cause things to slow down.

[ORAG]

Thanks for the help. I had just downloaded the beta yesterday and loaded over 2 mil hands, so the size is correct. It would be nice to be able to either import only my hands or separate the observed from the HHs I already have. Could I change to autoimport and direct it to the directory with all these hands to separate or is that just going to cause issues?

[Josh]

You can use the auto-import, but since it's meant to be used for as-you-play importing, it's much slower and less CPU intensive.