import mysqldb from dal import MySQLAdapter MySQLAdapter.driver = mysqldb
On May 18, 7:51 am, SergeyPo <ser...@zarealye.com> wrote: > Vasile, > > I am using Python 2.5 on Windows XP, > MySQL mysql Ver 14.14 Distrib 5.1.32, for Win32 (ia32) > InnoDB engine, UTF-8 encoding > > I have large database with lots of data, hard to reproduce here. > Application works fine on web2py version 1.86.2 and works with many > small errors in web2py 1.95, about 3 times slower. > For benchmarking I use my own app which includes heavy offline process > that I call with > python web2py.py -S advantage -M -R applications/advantage/modules/ > preparer.py > > It takes 12 hours under 1.95 (pymysql) and 4 hours under 1.86 > I am also watching on memory in task manager... > > I am experienced developer but I don't have time to dig in third party > modules like pymysql, esp. that I know that before the whole thing > worked much better. > > Thank you! > Sergey > > On 16 май, 17:19, Vasile Ermicioi <elff...@gmail.com> wrote: > > > > > > > > > and python version please (needed for benchmarking) > > > pymysql also have the advantage to run on top of jython and pypy with no > > efforts > > and I guess that on top of pypy it will have much better performance