PDA

View Full Version : Database Size and slowness



muddyjeremy
06-04-2010, 10:23 PM
I have a database which has been backed up and restored on a new computer. It's a netbook, but I'm not having any trouble with processor utilization etc. 2GB RAM. The netbook has a Vertex OCZ SSD in it which I thought would solve my problem. The problem is my database is slow, imports at less than .5 hands a second and it's causing my stats to not refresh fast enough in the HUD for 6 max rush poker on full tilt. I did every one of the speed tweeks for windows 7 and also did a full vacuum analyze and reindex. I then did a purge of all hands except mine on all dates, then did a vacuum analyze and reindex again. I also checked the log folders that grow large and the size is not in there. All the size is in the data/base folder. My database size is still 6+ gigs after restore even though I basically purged everything. It only purged a few thousand hands when I ran the purge. I just want the stats from other players I don't need the hands. I'd like to know any help on how to finish getting the size of the database down and getting it to run faster. On a SSD I would think I wouldn't have any problems. I did create a new database and it's as fast as I could want, but I'd really like the stats from the old database so I'd like to use it if possible.

Thanks, Jeremy

UWjoe
06-05-2010, 12:30 AM
im very interested in this as well, the program would be more valuable if it didnt restrict how many tables i could play by overloading my CPUs

netsrak
06-05-2010, 07:40 AM
Did you purge via Options -> purge hands?

How many hands do you have in your database? FAQ - Hold'em Manager Poker Tracking Software :: Check Total Amount of Hands in Database (http://faq.holdemmanager.com/questions/115/Check+Total+Amount+of+Hands+in+Database+)
In general you should calculate with about 10 GB hdd space for 1 Mio hands.

You can switch off the postgresql log because this is not needed
FAQ - Hold'em Manager Poker Tracking Software :: Large Log Files (http://faq.holdemmanager.com/questions/85/Large+Log+Files)

this might help too: FAQ - Hold'em Manager Poker Tracking Software :: Advanced PostgreSQL Tuning (http://faq.holdemmanager.com/questions/89/Advanced+PostgreSQL+Tuning)

In general a netbook is not build to handle lots of data in a database. It seems like your SSD is not the fastest one although i agree that .5 hands/sec is not ok. Please check all the things i posted before and if it remains the same i'll forward this thread to our tuning specialist Patvs :)

muddyjeremy
06-05-2010, 11:44 AM
At this point it only says I have 23,679 hands but I still have 6+ gigs used in the database. No I used options-> Observed hand history configuration-> Purge hand history options to purge because I thought you had to do that to keep the statistics. If I do options-> purge hands it says it will only keep the player statistics until the cache rebuilder is completed. If I'm misunderstanding this let me know but I don't want to lose player stats.

netsrak
06-05-2010, 11:49 AM
Please try options->purge hands, there is no difference between this two purge options.

After that run a vacuum/full over your database