Number of hands don't match

[etay0330]

I'm trying to clean up my database a little. Ever since I upgraded to 1.09 beta 27 it's been running extremely slow.

I notice something strange however. When I look at my Reports section with All Hands selected, it shows 487k hands. When I did a query in pgAdmin to check how many hands are in my database it shows over 600k hands. Why is that?

[netsrak]

Possibly tourney hands, omaha hands or sth. else?
A difference between this 2 values is normal but i think in your case the difference is to high. So its possible that your database is corrupt somehow.

I would suggest you create a new database and import all hands again. http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146

[etay0330]

I've purged all the tourny hands and I don't play any other games. Well, not enough to have that much difference in the numbers.

I'll try to reimport all the hands and create a new database. We'll see what happens.

[etay0330]

Quick question. If I create a new database and reimport all the hands from my archive hand history folder, will I still see the notes I've taken so far on the players? If not, what do I need to do to fix that?

[netsrak]

You need to export and import them too: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=119

[fozzy71]

Observed or datamined/purchased hands?