[SixthSense]

[ QUOTE ]
[ QUOTE ]
Well, I restarted my comp, ran adaware, and now it's going at about 8,000 hands/hour

[/ QUOTE ]

me too importing into the ptagg database has gotten really slow.

Like 10K-15K hands per hour after a fresh reboot and running no other programs. My pc has 4GB of RAM. I have vacummed the ptagg database almost everyday.

I aggregated one mining database of 2.2Million hands. Now I'm aggregating my second db-my main playing databse for the last year about 500,000 hands.

I wanted to aggregate one last mining database of ~2.50 Million hands.

It seems to be slowing way down as aggregate more data despite the precautions I'm taking. Its just time-consuming that's all.

averaging about 16K per hour now after another reboot.

The memory usage starts at ~100K and climbs up to ~400K afer 6-7 hours-definite memory leak.

[/ QUOTE ]

To be honest I haven't tested myself on very large db's, just my db with about 150k hands. It might be that it just takes a long time at that size.

Like you noticed, there is a memory leak, so restarting it every 4 hours will help too.

I'm going to release a new build that lets you change some of the PTAgg settings, this might help speed it up. One setting is the "Batch Size", its currently 100 Hands per batch. It might be that changing this to 500, 1000, etc will speed things up. It will probably take longer to do the one batch, but if its more efficient then overall it will be faster.

-Ben