hm database slow

[deepfried]

my hm seems to be much slower than it used to be. i have approx 1 mill hand in it.

is there any way to optimize it so thats its quicker to run reports etc?

[morny]

Please follow the tips in this thread and it should help http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html