*Hello M. Bayer
Ok i understand now what it is strange
My configuration
I m on windows xp pro sp3
Python is 2.5.2
SqlAlchemy is 0.5.6
Dell optiplex 755
Intel core 2 duo e8300
2go ram
**
I dont pass any paremeters in create_engine, is it wrong?*
chaine =
I does a mistake in my last, that is the results (error in parameters of
mysqldb connection)
Local database
Update 1000 MySQLdb 0.0319998264313
Update 1000 SqlAlchemy 0.265999794006
France-Tunisia
Update 1000 MySQLdb 10.391324
Update 1000 SqlAlchemy 42.157924
Sorry
2009/10/2 Christian
Hello,
I tried all the method to compare the different methods :
*TEST CODE*
xref = time.time()
self.UtilisateurCourant.Dispo = 1
session.merge(self.UtilisateurCourant, dont_load=True)
session.flush()
print With ORM dont_load,
Christian Démolis wrote:
Hello,
I tried all the method to compare the different methods :
*TEST CODE*
xref = time.time()
self.UtilisateurCourant.Dispo = 1
session.merge(self.UtilisateurCourant, dont_load=True)
session.flush()
Michael Bayer wrote:
Christian Démolis wrote:
Hello,
I tried all the method to compare the different methods :
Here's a decorator I would advise using:
http://stackoverflow.com/questions/1171166/how-can-i-profile-a-sqlalchemy-powered-application/1175677#1175677
Also I would advise
With debug mode it seems to take 0.15 second, my timer print 0.45 s
i don t know why this difference?
2009-10-01 17:00:38,586 INFO sqlalchemy.engine.base.Engine.0x...7f50 UPDATE
utilisateur SET `Dispo`=%s WHERE utilisateur.`IdU
tilisateur` = %s
2009-10-01 17:00:38,586 INFO
Christian Démolis wrote:
With debug mode it seems to take 0.15 second, my timer print 0.45 s
i don t know why this difference?
2009-10-01 17:00:38,586 INFO sqlalchemy.engine.base.Engine.0x...7f50
UPDATE
utilisateur SET `Dispo`=%s WHERE utilisateur.`IdU
tilisateur` = %s
2009-10-01
Maybe because the database is in Tunisia and my Computer in France.
I don t use sqlite, i use MySQL.
I just did a test on internet in Tunisia, 39kbits/sec upload and
417kbits/sec
2009/10/1 Michael Bayer mike...@zzzcomputing.com
Christian Démolis wrote:
With debug mode it seems to take 0.15
Christian Démolis wrote:
Maybe because the database is in Tunisia and my Computer in France.
I don t use sqlite, i use MySQL.
I just did a test on internet in Tunisia, 39kbits/sec upload and
417kbits/sec
right but, you had these results:
MySQLdb - .09 seconds
ORM - .3 seconds
so, network
Christian Démolis wrote:
Thx for your answer.
MakeReleased is a method of com object windows agent (self.agent =
DispatchWithEvents('CosmoAgent.clsCCAgent', Evenement))
It takes 0 second to execute as we can see in the execute print
yes I realized later there were two blocks of timer calls.
Christian Démolis wrote:
i made a test
i did that without sql alchemy orm:
import MySQLdb
import time
# Establich a connection
db = MySQLdb.connection(host=192.168.45.28,
user=apm,
passwd=apm,
db=test_christian)
# Run a MySQL query from
11 matches
Mail list logo