1.10 Beta - Incredibly Slow?

[mr_mooray]

Hi, I recently updated to the 1.10 beta (from 1.09) and since then my database has been very slow in comparison to what it was before I updated.

Even when I just want to see what hands I had marked in a session it takes about a minute to display them - and then sometimes it doesn't even show the hands I marked but all of the hands from the session.

It seems as though something has drastically changed since I have updated and would like to know if there is something I can do.

At worst case scenario how can I remove the beta version completely and use the current stable release.

PS I also ran vacuum and purged all hands recently with no real difference.

[fozzy71]

I have never noticed a slow down from one beta to another. If you want to try reverting, you can download older versions from this thread - http://forums.holdemmanager.com/showthread.php?t=23748

Do you have the same performance problems if you make a new DB?

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

Some of the most important things, imo:

- Remove the WinnerName, WinnerCards and WinnerWon from the Options > Hands View Column Selecto
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Smart Defrag.
- Do a Cold Boot (Shut Down > Start) before you use HM again

[mr_mooray]

I do most of those things mentioned relatively often. I noticed the change as I moved from 1.09 STABLE to 1.10.08.

I would just like to revert back to 1.09 stable if possible.
How do I do that, or do I need to completely uninstall and reinstall again ? Ill do it but would like to know exactly how.

The problem could be something else but it seemed to happen as soon as I updated and I can't think of anything else?

[mr_mooray]

I just tried to make a new database and imported some hands and now it works like normal. :)

Im not really sure what that means - I would like to import my old hands, but would that slow everything down to a halt again ?

Im running it on a i5 750 with a dedicated WD raptor hard drive with the db on it so im surpised that it would run so slow espeically just for a couple of hands.

[netsrak]

In general a database becomes slower the more data you have.

But you should try to fill up your new database and see how it works.

[mr_mooray]

My old database is Ascii and the new UTF8 does that make a difference? Could I convert the old one to UTF8.

[PunkAss]

Prefetching for Full Tilt still not fixed with beta 8 it seems. Any way for this to be noted in the future so that I don't continue installing the latest beta then having to revert back?

[fozzy71]

My old database is Ascii and the new UTF8 does that make a difference? Could I convert the old one to UTF8.

No, you cant convert it, AFAIK. You should just use the new DB. If you import all your old hands make sure you do maintenance on the DB every few 100k hands imported.


Prefetching for Full Tilt still not fixed with beta 8 it seems. Any way for this to be noted in the future so that I don't continue installing the latest beta then having to revert back?

Last I heard, the developer was unsure if it was even going to be possible to fix. If/when it is fixed, it will probably be mentioned in the release notes/thread.

[Cherufe]

I have the same problem
Since the new beta 8 when I start auto importing is so much slower....

Don't have a lot of new hands since the update and I also vacuum my DB/defrag my hdd often, so I don't think the size is the problem.

[mr_mooray]

I have the same problem
Since the new beta 8 when I start auto importing is so much slower....

Don't have a lot of new hands since the update and I also vacuum my DB/defrag my hdd often, so I don't think the size is the problem.

It really did seem that after the update everything was much slower. MY Db is 30gigs big as I have mined hands but still it took for ages just to show some marked hands after a session. I have used and done most of the things suggested and it didn't really make much difference.

Now I have just a new database and will use that, I thought starting a new one every year is probably a good idea. What could the new beta have changed?

[netsrak]

We added the database changes for the language support. This may slowdown the import etc. a little bit but not to much.

[FacePlant the Felt]

in the recent updates, HEM has slowed drastically for me!
startup is double slow,reports are slower than usual

new database,fresh import, 216k hands

[netsrak]

I'll forward it to the developers

[PeFro]

same here, even reports of daily played hands much slower

[LostCause]

+1

Start-up is extremely slow and reports are running much slower.

[mr_mooray]

Now that ive made a new database it seems a lot faster but if this is a problem generally with the new beta I would like to remove it, and just use the old version that seemed to run better.

I actually read that .10 should be running faster on multi core cpus, and im on a i5 750?

[Rapala]

1.10.5 was fine for me but since updating to the latest 08 beta , reports, graphs, filters are taking more than double the speed

[Rapala]

I have now reverted to 1.10.05 but the speed is still terrible. When i upgraded to 08, it said it was making changes to the db for multi currency support. It seems likely that these changes are the culprit. I would like to edit my statement of things being twice as slow to something more like 5 times as slow!

[mr_mooray]

Would like to hear what the developers have to say about this? I would like to avoid having to uninstall and reinstall everything just to get back to the current 1.09 STABLE release...

[Rapala]

We added the database changes for the language support. This may slowdown the import etc. a little bit but not to much.

I'm afraid it appears this slowdown is a huge amount worse than expected. Would be great if you can release a patch that reverses the changes made to the database.

[Rvg72]

We're looking into why this is happening to some people and we'll come up with a good solution to get things running well again. For people with the issue, it would be helpful if you could let us know how many hands apx you have in the DB and how many players and if the problem happens on certain reports / tabs and if you are running these reports on yourself or other players

Roy

[Rapala]

I have 15000 players with about 400k personal hands and probably 3-5 million total hands. I have been running filters and reports of my own alias and is slow with reports, filters and graphs. Auto import is still normal speed and the hud is not affected.

[mr_mooray]

I have 163079 players, and about 250,000 hands from my alias. I often purge hands from other players; keeping just their stats.#

When I try and simply look at the hands that I have marked today, or sometimes just look at my monthly sessions it takes a lot longer than usual.
Sometimes reports dont seem to run at all because its so slow.

Now I use my newly created database (which doesnt include all the old hands) and its running fine.

[Rvg72]

ok thanks for this information. I have a couple things in mind that should fix this and that will come in 1.10.01 (we are releasing 1.10 today which is very similar to the last 1.10 beta)

Roy

[dan233]

I m having this problem too since I downloaded the latest release.
When I zoom into the graph for example. the entire application freezes for a while and sometime it even gets closed down because it s no longer responding according to a pop up window.
Never had this problem with the older version of HEM
I am then unable to restart HEM without restarting the entire computer.
I have 100K hands
10K players
Here s a pic:
http://img403.imageshack.us/img403/2558/hemprob.jpg (http://img403.imageshack.us/i/hemprob.jpg/)

[fozzy71]

Is UAC on or Off? Which firewall and anti-virus do you use?

Please give HoldemManager Administrator rights if you haven't -

1) Go to C:\Program Files\RVG Software\Holdem Manager (Program Files (x86) if you have the 64bit version)
2) Rightclick the HoldemManager.exe and choose "Properties".
3) Go to the Compatibility Tab and select "Run this program as an Administrator".
4) Do the same for HMHud.exe and DBControlPanel.exe


Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems


Have you tried using a new test DB?

*Try creating a new UTF DB - http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/showthread.php?t=20754

[dan233]

Is UAC on or Off? Which firewall and anti-virus do you use?

Please give HoldemManager Administrator rights if you haven't -

1) Go to C:\Program Files\RVG Software\Holdem Manager (Program Files (x86) if you have the 64bit version)
2) Rightclick the HoldemManager.exe and choose "Properties".
3) Go to the Compatibility Tab and select "Run this program as an Administrator".
4) Do the same for HMHud.exe and DBControlPanel.exe


Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems


Have you tried using a new test DB?

*Try creating a new UTF DB - http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/showthread.php?t=20754
1.I m unable to give HoldemManager Administrator rights because the option is grayed out:
http://img30.imageshack.us/img30/4934/hemadmin.jpg (http://img30.imageshack.us/i/hemadmin.jpg/)
why? what can I do?
2. Any idea WHY some files (please see picture) are now highlightened in blue? what can I do about this?I think it might be due to the fact that I attempted to compress HD to free space but I just read that this might actually slow down the access to the files. I have HEM etc on this HDD drive. any way to reverse this?http://img69.imageshack.us/img69/223/compress.jpg (http://img69.imageshack.us/i/compress.jpg/)
3. would it be a good idea to move HEM to an empty, seperate HDD on my laptop(the HDD would be entirely dedicated to HEM only) ? how woud I do this without leaving out important elements?

[TylerD]

My database seems to be running reasonably, but I'm having a problem with some aspects of the UI. The main two issues are: restoring the program from minimised, it takes about 3-4 seconds to bring HEM up and also minimise and restoring the side bar. Not a major problem, but would appreciate a resolution.

[TylerD]

My database seems to be running reasonably, but I'm having a problem with some aspects of the UI. The main two issues are: restoring the program from minimised, it takes about 3-4 seconds to bring HEM up and also minimise and restoring the side bar. Not a major problem, but would appreciate a resolution.

Actually you can probably ignore this, restarting HEM seems to have done the trick. Ho hum :rolleyes:

[Rapala]

10.01 has not fixed the problem :(

[Rapala]

Fozzy, I don't see how doing the things you mention could fix a problem caused by an update. My db was working perfectly until I updated to the multi currency update and the changes that it made to the db. I'm sure that if I started a new db it would appear to work ok but that's just because there would be few hands in it.

The speed is hugely affected by how many hands it is dealing with. For example, when looking at my graph, when I load todays graph with 100 hands, it loads in a second, when I load my months graph with 15k hands it takes 25 seconds. My months graph used to take about 5 seconds.

[fozzy71]

Do you perform regular DB maintenance such as full/vacuum/analyze, reindex, stop postgresql, and defrag? Did you do the other things suggested for performance help in my first reply?

My DB is 250k+ hands and I can pull a graph of my alias up in just a few seconds. Same with any of the other screens like Reports or Sessions.

Here are my performance suggestions again, with an updated link to our new FAQs.

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

Some of the most important things, imo:

- Remove the WinnerName, WinnerCards and WinnerWon from the Options > Hands View Column Selector
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+#manual
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Smart Defrag.
- Do a Cold Boot (Shut Down > Start) before you use HM again

[Rapala]

will try that out. thanks Fozzy

[Bacco777]

I don't know what happened but your last update really slowed down HM. When selecting Table Scanner it takes a while for HM to even respond.

I have done regular dbase maintenances etc and am using a ssd disk. I also pretty much know what I'm doing and haven't had this problem before.

Yesterday I reloaded my dbase and still am having these issues. My whole pc freezes when HM isn't responding.

[Rapala]

I'm currently using postgres 8.2, would upgrading to 8.4 help with the performance?

[netsrak]

8.2 is pretty old so this might help a bit.

[Azalin]

Since the update I am having same problems with the DB. I am using postgre 8.3 version and the main problem for me is that displaying hands in the sessions tab takes an awfull lot of time WHEN it works..

I cannot see the hands that I have played even if I dont select "All" and leave it to "Last 100". I am having similar issues when I am in the reports tab (with the hands shown). I have a big database (24-25mil hands currently,100k+ imported daily) and I vacuum/reindex/defrag every 2 days. I did not have this performance issues with the 1.09 versions.

When I click on the mentioned tabs CPU goes to 25% (1 of the 4 cores is working full on a postgres.exe process) and it stays that way for a looong time (more than 5 minutes etc) before displaying hands.

What can I do to fix this? I've tried most things fozzy mentioned to no avail. Should I upgrade to 8.4 posgresql and created new UTF DB? Would I see any major speed improvements? I use XP Pro BTW and not vista/Win 7.

[netsrak]

Did you try this?


- Remove the WinnerName, WinnerCards and WinnerWon from the Options > Hands View Column Selector

[inavacuum]

I too have noticed the latest update slowing things down somewhat. Not enough to to bother me, but I do wonder why some aspects of HM are so slow. For example, I've just imported a large # of hands into both HM and PT3. HM managed 50-80h/s, PT3 never dropped below 150h/s.

[netsrak]

You can't compare HM and PT3 import because PT3 has some parts of the import (clustering, caching etc.) in a different process.

[inavacuum]

Fair enough :)