Super slow database

[anytwocantyou]

Hey guys, I have tried everything on here and 2+2 to try to speed up my HEM database. I have about 300K hands and it just takes forever to load up my sessions and graphs etc. Can someone teamview and figure this out I am beyond wits end.

[fozzy71]

I would suggest you do the majority of the things in this thread: http://208.109.95.123/forum/showthread.php?t=11194

Some of the most important things, imo:

- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex
- SQL Tuning Wizard
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
- Do a Cold Boot (Shut Down > Start) before you use HM again

[anytwocantyou]

I would suggest you do the majority of the things in this thread: http://208.109.95.123/forum/showthread.php?t=11194

Some of the most important things, imo:

- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex
- SQL Tuning Wizard
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
- Do a Cold Boot (Shut Down > Start) before you use HM again

already did all of those. I also just installed postgres8.4 and the HEM beta and reimported all of my hands from original .txt and I am seeing the same issues.

[netsrak]

I'm not sure whether we can help you with this. Possibly your computer is just too slow?

Anyway: Please schedule a remote support session with our support manager. Email fabio@holdemmanager.net, with a link to this thread and your forum name, so he can setup a Teamviewer session.

[anytwocantyou]

running a core duo laptop and XP with 2GB of ram. can the DB not handle 300K hands or something

[netsrak]

Seems to be ok. So please email Fabio.