Setting up second database?

[snoopy]

Hello, I am playing nl100 6 max. I recently purchased 5 million hand history files for nl200 and loaded them into my database to analyse. This has made poker tracker run very slowly. Is there anyway I can partition these 5 million hh files into a separate database so as to not impact on my computers performance?

Please provide the steps.

Thanks

[kraada]

Yes you can do this. Honestly what will be faster though is importing all of your played hands into the new database and make the old database your observed hands.

To create a new database, click Database --> Database Management --> New, call the database what you would like and click Create.

To change what database PT3 is using for the main PT3 window click Database --> Set Active Database and pick one of your databases. Whichever database is set Default on the Database Management window will be the one that starts as active.

Set the second database as active and use the manual import to import all of the hands into it.

Also: did you run a full housekeeping after importing all of those hands? If not you really should as that alone should speed things up significantly.

[Laur]

Hi

I have about 3 mio. hands in my DB and it also runs slow. Are there anything to gain by making a new DB, or can I purghe a lot of the hands (I do not need the specific handshistory as long as I do not delete the stats on any players)

Best regards

Laur

[WhiteRider]

Purging hands will remove the stats as well as the hand history text. The HH text doesn't really affect performance as it is only referenced when you replay a hand or view the hand history detail. You can split your databases by date for example (see the Tutorial: Managing Multiple Databases) - the HUD can use stats from multiple databases but you can only use the tracker with one database at a time.