Frequent problems with databases

[marek_heinz]

Hey, I've been experiencing frequent issues with my HEM, usually its something like not correctly importing/recognizing hands and sometimes it just plain doesnt start and gives some error like problems with reindexing or sth like that...

I recently reinstalled windows and it just happened again, when I create a new DB, it works fine again.

I use a Kingston SSD so I suspect that might be a reason ( I read SSDs dont do well with postgres), also sometimes my computer before loading windows runs some chkdisk control, after which the malfunctioning happens often

I use win 7 64bit.

Any thoughts?

Thanks in advance

[Patvs]

SSDs work really well (performance-wise) with PostgreSQLs.

If your computer often performs a chkdisk upon startup, it can be caused by:
a corruption in your Windows installation
"bad clusters" on the harddisk (bad cluster don't exist in a SSD, but there could be a similar issue where the SSD can't access certain blocks): updating the firmware of the drive might this

Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

[marek_heinz]

Disabled the indexing in SSD, hope that helps, thanks for the link

[olliepower]

Thanks for the info