PDA

View Full Version : Import performance speed



SootedNinjas
12-11-2008, 03:09 AM
I just bought and installed for the first time HEM 1.07 starting with an empty DB.

When the import started the 1st batch of hands of about 500k the Hands/s was around 140 but by the time the batch was complete it was down to 70 hands/s. It was slowly decreasing as the import progresses.

Now I am on my second batch of another 500k hands and it is processing 40 hands / second.

What's up with this ?

Anybody, anyone ?

Al1
12-11-2008, 08:55 AM
Escalated to morny (Support), he will answere asap.

SootedNinjas
12-11-2008, 03:22 PM
Now is down to 35 hands/s

morny
12-11-2008, 05:02 PM
As the database increases the import speed will get slower but the actual speed of displaying hands shouldnt be effected much. There can also be a big diffference between type of hands i.e HU vs FR and even some sites like Party have a much slower import rate. I wouldnt pay too much attention to the start rate however as its like downloading it takes a while to average out however it is a bit unusual that it dropped from 70 to 35 so i would recommend doing a defrag of your hard drive especially if you havent done one lately.

Roy has said hes going to look into rewriting this to improve things again but since its such a big job it will be a couple of months before he can get it finished.

TierTier
12-12-2008, 09:30 AM
SN,

I'm in a similar boat as you and am down to 11-13 h/s when I grab the hands from yesterday in the morning.

SootedNinjas
12-12-2008, 01:44 PM
After a defrag as suggested I imported the next 500k hands and the rate was at 45 hands/s for these batch.

After that batch the rate went down but it has been holding steady for the last 1.5M hands @ 35 hands/s.