PDA

View Full Version : Player Stats Differences



Biju
06-04-2009, 08:41 AM
When I click on the notes icon to review current stats trend compared to whole data base stats I have some players who have more hands in their Current Statistics box than in the whole of the database. How is this possible?

morny
06-04-2009, 03:53 PM
This is pretty weird, do you have UAC off? Maybe we can do a teamviewer session to investigate morny@holdemmanager.net and also link to this thread

Biju
06-04-2009, 04:45 PM
What is UAC and I'll check

morny
06-04-2009, 05:06 PM
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

Biju
06-04-2009, 10:31 PM
This FAQ deals with Vista. I have XP. Do you have a FAQ explaining the steps for this or is it just valid for Vista.

stretch00
06-04-2009, 10:35 PM
maybe your database is corrupted do you know how to export the HHs?

Biju
06-04-2009, 10:42 PM
no but I'm sure I can find how. What are you suggesting exporting and then re iimort into a different named database?

stretch00
06-04-2009, 11:00 PM
because you probably need to start another database,it sounds like that DB got corrupted.
but you should export you HHs in case something goes wrong with creating a new DB.
How big is that DB how many HHs? I would start there as the cause and eliminate it, by exporting HHs then creating a new DB and re-importing. I had something similar happen but it was with the amount of players.

Yeah, Please export your hands from the old database http://www.holdemmanager.net/faq/afm...aspx?faqid=173 (http://www.holdemmanager.net/forum/../faq/afmviewfaq.aspx?faqid=173) then create a new database http://www.holdemmanager.net/faq/afm...aspx?faqid=146 (http://www.holdemmanager.net/forum/../faq/afmviewfaq.aspx?faqid=146) and reimport the hands into the new database

Biju
06-05-2009, 12:38 AM
Got around 1.5M Hands and around 14k Players. Can't imagine this is a huge amount, but my HEM does run a lot slower these days and I should look at some of the FAQ's on optimising it.

So I'll try setting up a new data base as you suggest and take it from there.

morny
06-05-2009, 12:13 PM
You could just export last months hands first http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=187 and see if it persists with this sample rather than importing all the hands and finding out its the same as it might take a long while to import all those

btw there is no equivilant of UAC on XP its a new vista feature so you dont need to worry about that

stretch00
06-05-2009, 01:48 PM
Here's a thread with some SQL performance stuff. Some of it is kinda advanced,and some is dirrected at posgreSQL older versions.So give it a good look and be careful.Top 10: HEM performance increase tips (http://www.holdemmanager.net/forum/showthread.php?t=11194)
I hope you got Morny's post!! I didn't even think to export a smaller sample size.1.5million is pretty big!