Re: MySQLdb slow on MySQL 5

2006-02-24 Thread Jarek Zgoda
Magnus Lycka napisał(a): > For those who don't know, Oracle bought a small Finnish > company which developed the transaction-aware table- > backend for MySQL. As far as I understand, this means > nothing for GPL licensed MySQL installations, but if > MySQL sells commercial MySQL-database with tran

Re: MySQLdb slow on MySQL 5

2006-02-24 Thread Magnus Lycka
Gerhard Häring wrote: >> Oh well, Oracle will probably kill MySQL soon. > > Did you read too much Slashdot to spread such FUD? :) I guess I should have used half a smiley, since I was only half serious. Buying InnoBase OY was...an interesting move. Cheap too! It's a while since I visited /. For

Re: MySQLdb slow on MySQL 5

2006-02-24 Thread Gerhard Häring
Magnus Lycka wrote: > [EMAIL PROTECTED] wrote: > > I'm not calling COMMIT at all. > > Then you must be using autocommit if your records stay in > the table. An DB-API 2.0 compliant adapter should turn off > autocommit by default! Does MyISAM even support proper > commit handling? [...] No, it d

Re: MySQLdb slow on MySQL 5

2006-02-24 Thread Magnus Lycka
[EMAIL PROTECTED] wrote: > I'm not calling COMMIT at all. Then you must be using autocommit if your records stay in the table. An DB-API 2.0 compliant adapter should turn off autocommit by default! Does MyISAM even support proper commit handling? Oh well, Oracle will probably kill MySQL soon. G

Re: MySQLdb slow on MySQL 5

2006-02-23 Thread [EMAIL PROTECTED]
Gerhard Häring wrote: > > Maybe you're running in autocommit mode. I. e. an implicit COMMIT is > done for each insert. This slows any database down. > > Or are you calling commit() yourself too often? > > -- Gerhard I'm not calling COMMIT at all. I'm using MyISAM tables. I'll check on autocommit.

Re: MySQLdb slow on MySQL 5

2006-02-23 Thread Gerhard Häring
[EMAIL PROTECTED] wrote: > Hi. > > I have a Python program that parses a file and inserts records into a > database with MySQLdb. I recently upgraded to MySQL 5.0.8, and now my > parser runs *really* slow. Writing out to CSV files is fine, but when I > try to insert the same records in a MySQL5 da

MySQLdb slow on MySQL 5

2006-02-23 Thread [EMAIL PROTECTED]
Hi. I have a Python program that parses a file and inserts records into a database with MySQLdb. I recently upgraded to MySQL 5.0.8, and now my parser runs *really* slow. Writing out to CSV files is fine, but when I try to insert the same records in a MySQL5 database, it slows to a crawl. Using My