How many hands can you import into a single pt3 db

[Total Sweetheart]

Is there a limit?

Also ... I started a db with my stats from Absolute, Bodog and Stars together. Is there a way to take out my stats from AP and Stars and put them in separate dbs?

[mxrider]

There should be no limit on the # of hands. As for your other question, it has been soo long since I used PT3, I'm going to defer to someone else.

[podbelski]

Just some thoughts...

All the data stored in a 3rd-party database (PostgreSQL for PT3&HEM by default). So, it comes to how much data can the DB engine handle on your hardware without serious performance degradation.

This mainly depends on HDD speed/capacity, DB tables architecture and SQL queries optimization. The problem is for really huge amount of stored hands some database queries will start to work really really slow.

My guess is until you have tens of millions of hands in DB there shouldn't be serious problems. I'm almost sure this question was (is) discussed on PT3/HEM forums or covered in their FAQs/docs.

If you'll find some real numbers it would be interesting to see them here, just in case.

2nd, I haven't seen any way to manipulate already stored data in PT3/HEM programs, though I haven't searched for them. I'm pretty sure it is possible to do what you are asking about the hard way (manually via the DB admin tools and/or handwriting SQL queries). Alas, some programming skills will be necessary for that.

Upd: you can just filter all the records that you wish to move out of DB and simply delete them (it's easy), and then create separate DBs for Absolute etc and re-upload hands into them from original HH-files.
Also, if you don't have original HH-files anymore, you can Export hands to HDD prior to deletion, and then load them into new DB. At least HEM allows this by right-clicking on selected hands. Ugh, hope I put it clear enough and haven't confused you

[Total Sweetheart]

That's awesome pod, thanks for the good info

About deleting the hand histories from the file directory on my hard drive, is this something I need to be doing?

I was under the impression that the files are so small that it would take a massive number of hands to even begin to effect my computer's perfomance.

(I have an 8gb hard drive with an i7 processor, if that makes any difference)

[podbelski]

i7 is a nice proc (I have worse), but 8Gb HDD seems to be a mistake - modern PCs have at least 80Gb, otherwise I don't understand how it works for you at all Or did you mean 8GB of free space?

There is no need to delete original HH-files, you can estimate their size roughly like 1hand=1kb, so if you played 100k hands then the files will take about 100Mb on your HDD, which is not a big deal

[mojo6911]

For the UB/Absolute hands, you can filter them from the DB so they don't show up. I wouldn't get rid of them completely.

[Total Sweetheart]

Originally Posted by podbelski

i7 is a nice proc (I have worse), but 8Gb HDD seems to be a mistake - modern PCs have at least 80Gb, otherwise I don't understand how it works for you at all Or did you mean 8GB of free space?

Oops I meant to say it has 8gb RAM. Hard drive is 600gb. I get confused with all the computer abbreviations and lingo.

[podbelski]

Yeah, that what looks like the right numbers