MAJOR FreeEMS Binary Log Loading Performance Increase
Posted: Sun Oct 30, 2011 6:59 pm
I've not finished for the day yet, with about 6 hours to go until I go to bed and 4 or so tomorrow morning before it needs to be online for Ben, and with dinner to cook and eat and clean up after and a shower to have, that's probably 6 hours total left to do work on it, BUT, so far:
(131314 / 12073 ) * (160000 / 51173) = THIRTY FOUR TIMES FASTER :-)
Loads 160k records in 12 seconds or less compared to 51k records in 2.15 minutes before. Also, This is from a file with 207k records and the new code stays up and displays whatever it gets to, as well. The old code falls over when it runs out of memory. The new code detects memory doom and prevents it.
Not a bad bit of performance increase there :-)
Let's see what else I can achieve before I put the code to sleep tonight!
Fred.
(131314 / 12073 ) * (160000 / 51173) = THIRTY FOUR TIMES FASTER :-)
Loads 160k records in 12 seconds or less compared to 51k records in 2.15 minutes before. Also, This is from a file with 207k records and the new code stays up and displays whatever it gets to, as well. The old code falls over when it runs out of memory. The new code detects memory doom and prevents it.
Not a bad bit of performance increase there :-)
Let's see what else I can achieve before I put the code to sleep tonight!
Fred.