MySQLdb slow on MySQL 5

[Gerhard Häring]

Magnus Lycka wrote:
> timothy.williams at nvl.army.mil 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 doesn't. And COMMIT is then simply a no-op if it doesn't raise an 
error already.

> Oh well, Oracle will probably kill MySQL soon. 

Did you read too much Slashdot to spread such FUD?

> [...] I'd use a real database system.

MySQL 5 could be described as one, according to the feature list, and if 
you use a transactional table type.

I myself won't bother with it because PostgreSQL is still more 
featureful that MySQL 5, has a much longer track record with these 
features proven stable and a more liberal licensing.

-- Gerhard