[2easy]

[ QUOTE ]
[ QUOTE ]
ben,

ive signed up for 1 year on the hope that i can get this all operating correctly.

but, after having built the aggregated db, and refreshing to get stats, it's taking around 45 minutes to do 125 tables when i have my normal "playing" programs running.


[/ QUOTE ]

These speed issues are most likely due to Party's "Monster Tables". Did you try running the "De-Monster" script found here on this board?

-Ben

[/ QUOTE ]

uh, no, its not.

trying not to be short with you, but in the 4 sentences below what you quoted i wrote...

[ QUOTE ]
i turned off the "use aggregater," and had it just pull from my main db, and it then took from 30 to 90 seconds to score the same tables, 30 being the first time, and going steadily higher up to 90 secs for ensuing scoring.

my main db is about the size of all of my other ones combined, so using the aggregated mode shouldnt do more than double my time, if that. but going from an average of 60 seconds to approximately 40-45 minutes makes things unworkable.

i have demonster.ahk running at all times, regularly defrag, full vacuum daily, etc..

[/ QUOTE ]

if you did read what i previously posted, im wondering why you'd ask that and why you'd make that assumption that this was my problem.

anyway, going from a 60 second "pull" to a 45 minute "pull," is attributing quite a lot to "monster", even if that were the case. everything was the same, i was pulling from the same tables, etc., same configurations, etc., the only difference being using the aggregater or just using my main db.

please, let's try to figure this out. as i said, i have already signed up for the full meal deal. now id just like to get things working right.