hud not working on some tables

[sreticentv]

I suspect this is maybe because too many notes are in the database. I wrote an app that adds notes to the hem database and a new version writes way more notes now I've had two people with large databases say that the hud on some of their tables doesn't show up anymore.

Is there some kind of logging I can ask them to turn on to diagnose the problem? The only table my app writes to is hemplayernotes

[netsrak]

This can have many reasons,
so in step 1 you should try to get more infos by letting them answer our Hud FAQ:
FAQ - Hold'em Manager Poker Tracking Software :: My HUD Doesn't Work (http://faq.holdemmanager.com/questions/48/My+HUD+Doesn't+Work)

[sreticentv]

This can have many reasons,
so in step 1 you should try to get more infos by letting them answer our Hud FAQ:
FAQ - Hold'em Manager Poker Tracking Software :: My HUD Doesn't Work (http://faq.holdemmanager.com/questions/48/My+HUD+Doesn't+Work)

I have a theory on why this is happening. There is no index on player_id in your hemplayernotes table. So if someone has tens of thousands of rows and opens a dozen or more tables on a computer that isn't a database server, seems like there would be problems.

Am I overstepping my bounds to have my app add an index to that column?

[netsrak]

You can try it but please backup your database before doing this.

And please let me now the results. :)

[sreticentv]

You can try it but please backup your database before doing this.

And please let me now the results. :)

I tried it and it looks like there's a small performance increase. It's tough to quantify exactly but it definitely hasn't caused any problems that I know of.