Ever since I finished the telnet module to give me real time stats about the system I’ve been puzzled. I was watching message as they went through the system and counting. I counted to 15 or so and the system was telling me they took 50 seconds.
Finally I saw one that I counted to 30 and it told me 4,000 seconds.
Turns out I had a glitch in my math that I was using to generate my stats, or rather my SQL statement that was doing the math to generate my stats. Because of that my average time literally went from 280 seconds for each message to 89 seconds and it’s still going down slowly.
So what that means is that for the past week I’ve been trying to optimize the system with bad numbers. Which explains why things that I thought would help didn’t do as well as I thought they would.
But now, officially I think I have the back-end optimized the way it needs to be and I’ll be working on adding more features again.