How do you find out how many hands in a DB?

[oracle3001]

With PT4, how do you find out the total number of hands stored in a DB? i.e the information that used to be stored under in the Site Summary table under the Summary Tab in PT3.

[kraada]

The simplest way is probably to just create a report on the My Reports page in the Player section without any default stats - just show Hands and uncheck "Filter on Active Player" in the blue Filters link - that will tell you how many hands are in the database.

[oracle3001]

Hmmm...just done that, and something not quite right. It returns that I have over 7 million hands in a particular DB and I know for a fact that I don't have that many hands in the DB.

Edit:- Just tried another DB...and came back saying it had 1.7 mill hands. This DB is simply one I converted from PT3 (not added anything new in since conversion) and checking the existing PT3 DB size, it says 380k hands.

[kraada]

I see what's going on - scratch my prior advice that is counting single hands multiple times (once per player dealt in).

A better way that I just tested:

Create a Hand report with just Hand #. Change the drop down at the top right to show All Hands and untick Filter on Active Player. The total number of hands will be shown in the summary line at the bottom left - the Hand report won't double count.

[oracle3001]

Thanks, that worked, but is extremely slow to report. It took 3 minutes to complete on a 380k hand DB. I don't know if it is connected to the issues I reported in this thread?

https://www.pokertracker.com/forums/vie ... 9&start=10

Tried on another DB and got a "bad allocation" error, whatever that is.

Edit:- Been waiting 15 minutes now (and still not completed) for the report to return on a 3rd DB that I think has around a 1 million hands. That report has just Hand# and that is it.

[oracle3001]

After I think nearly 30 minutes without completing, PT4 crashed. Crash report sent via automated system if you are interested.

[kraada]

Thanks we'll look into it. It worked on my database without any problem but my database is small.

Of course if you want to do it by straight SQL:

SELECT count(distinct id_hand) from cash_hand_summary;

will get you the number you want as a query.