Ben
08-23-2011, 09:07 AM
Hi, I've been skimming the FAQ for help, but I thought posting here would be more efficient.
I moved my database over to my new Desktop a few months ago and everything was fine. I had almost identical database's on my desktop and laptop, whenever i needed them.
Then HEM 2 Beta came out. I got my code, downloaded it, was having trouble with it from the word go (i.e. importing all my hands). I never really got the time to get used to it like HEM (1) and my (very capable) new desktop started lagging. I ended up deleting HEM 2, to see if it was causing the problems, and decided I would reinstall at a later date when the lagging issue was seen to.
The first few times i started up HEM 2, i could see that it was auto-importing hands from my database, but it seemed to never end. Is it possible it may have made duplicates?
I have checked the database from my Laptop (the original database) and it is named "holdemmanager". I have just checked the databases on my desktop (in case dublicate(s) was made by HEM2) and there are 3 databases; "holdemmanager", "Holdemmanager 2" and "HEM2". The sizes of these (respecitvely) are: 8993KB, 1630MB and 11GB!
I have just checked the size of the database on my laptop (holdemmanager) and it is 7206MB.
When running HEM on my Desktop, the database it uses is HEM 2, it has info for hands against 223,000 players. I am not sure how many hands total as when i click on Tourney>>Hands>>ALL it takes too long to load. (I am a MTT player, not cash game)
Is 11GB just too big?
Could this be making my computer lag?
Could HEM 2 have caused the database to get this big by importing the same hands a number of times?
What is my best option, Vacuuming? moving the database to my other hard drive and defragging both?
Fwiw, in pgAdmin, it states for HEM 2 it has 4 backends (not sure what that means).
If any other information is needed, let me know. sorry for all the questions, and the pure essay.
Thanks
I moved my database over to my new Desktop a few months ago and everything was fine. I had almost identical database's on my desktop and laptop, whenever i needed them.
Then HEM 2 Beta came out. I got my code, downloaded it, was having trouble with it from the word go (i.e. importing all my hands). I never really got the time to get used to it like HEM (1) and my (very capable) new desktop started lagging. I ended up deleting HEM 2, to see if it was causing the problems, and decided I would reinstall at a later date when the lagging issue was seen to.
The first few times i started up HEM 2, i could see that it was auto-importing hands from my database, but it seemed to never end. Is it possible it may have made duplicates?
I have checked the database from my Laptop (the original database) and it is named "holdemmanager". I have just checked the databases on my desktop (in case dublicate(s) was made by HEM2) and there are 3 databases; "holdemmanager", "Holdemmanager 2" and "HEM2". The sizes of these (respecitvely) are: 8993KB, 1630MB and 11GB!
I have just checked the size of the database on my laptop (holdemmanager) and it is 7206MB.
When running HEM on my Desktop, the database it uses is HEM 2, it has info for hands against 223,000 players. I am not sure how many hands total as when i click on Tourney>>Hands>>ALL it takes too long to load. (I am a MTT player, not cash game)
Is 11GB just too big?
Could this be making my computer lag?
Could HEM 2 have caused the database to get this big by importing the same hands a number of times?
What is my best option, Vacuuming? moving the database to my other hard drive and defragging both?
Fwiw, in pgAdmin, it states for HEM 2 it has 4 backends (not sure what that means).
If any other information is needed, let me know. sorry for all the questions, and the pure essay.
Thanks