On Wed, Dec 7, 2011 at 8:38 PM, Ian Clelland <clell...@gmail.com> wrote:
> Hi, all ---
>
> This is a proposal to add support in Django for PyMySQL[1] as an optional
> replacement for MySQLdb.
>
> …
>
> PyMySQL is a pure python implementation of PEP 249 for MySQL, and supports
> Python 2.4 - 3.2, and MySQL 4.1 and higher. It is nearly a
> plug-in-replacement for MySQLdb (although there are a few compatibility
> issues that I have tried to take care of in Django backend code)
>
Hi Ian
Have you checked any performance testing comparing PyMySQL with MySQLdb?
Ideally, instead of just a single run, could we have some a/b
performance testing? At $JOB we use ministat[1] to statistically judge
a difference, we normally do a minimum of 6 runs of each in this order
- abababaaabbb. Record the times in a text file for each option, and
give to ministat to calculate min/max/median/mean/standard deviation
and calculate the confidence of a difference in the results.
An example with made up data (hope you have proportional fonts):
x mysqldb
+ pymysql
+--------------------------------------------------------------------------+
| + |
|x x x + x x * + + +|
| |____________A____|M_____|___________AM_________________| |
+--------------------------------------------------------------------------+
N Min Max Median Avg Stddev
x 6 2870 3200 3110 3046.6667 127.22683
+ 6 3050 3600 3300 3291.6667 190.83151
Difference at 95.0% confidence
245 +/- 208.615
8.04158% +/- 6.84733%
(Student's t, pooled s = 162.178)
Doing benchmarks is good, but having confidence in them is better.
There's a good post by Zed Shaw (well, it's a bit sweary and ranty) on
this topic as well[2]. If you aren't blessed with using FreeBSD, there
is a linux port of ministat here[3].
If you like, point me at some code and I'll run some benchmarks.
Cheers
Tom
[1] http://ivoras.net/blog/tree/2009-12-02.using-ministat.html
[2] http://zedshaw.com/essays/programmer_stats.html
[3] https://github.com/codemac/ministat
--
You received this message because you are subscribed to the Google Groups
"Django developers" group.
To post to this group, send email to django-developers@googlegroups.com.
To unsubscribe from this group, send email to
django-developers+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-developers?hl=en.
