[Dbbalancer-users] Preliminary performance statistics
Status: Alpha
Brought to you by:
xperience
From: Andrew M. <an...@ca...> - 2001-11-05 11:10:06
|
Hi All, This is way preliminary, but it looks so positive I just had to put it up here... |----------+------+-------+-------+---------+--------+--------+ | | Avg | StDev | Max | Min | Median | Sample | |----------+------+-------+-------+---------+--------+--------+ |Persistent| 0.056| 0.081| 12.674| 0.000361| 0.051 | 74371 | |----------+------+-------+-------+---------+--------+--------+ |DBBalancer| 0.020| 0.011| 0.758| 0.000417| 0.019 | 14684 | +-------------------------------------------------------------+ So connection pooling with DBBalancer appears to be giving me a 270% increase in performance for the queries in my application. I've attached an HTML table with further breakdown, showing how with DBBalancer installed today I beat the performance on every measure (except minimum) for any of the last seven days. Cool. The application in question is fairly tuned for performance, managing to get this particular component (the bit that gets a reasonable number of hits) down to around three simple queries. The performance statistics are measured by wrapping each query, so do not include any component of execution time for the script (or even the connection startup time) - just the queries themselves. Regards, Andrew. -- -------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 |