Re: mysql 5.5.9 dreadfully slow

[nick rulez]

Rick, you were right. I was comparing apples with pears. :)
My create table didn't specify the engine.
So in mysql 5.1 the stored procedure ran on a myisam table.
I just read on the manual that in the last version the new default engine is innodb.

show engines query confirms it.

I made a last test:

MYSQL 5.1

call date_random('1910-01-01',curdate(),500000);
-- myisam 26 seconds
-- innodb 14 minutes and 30 seconds

MYSQL 5.5
call date_random('1910-01-01',curdate(),500000);
-- myisam table 20 seconds
-- innodb 7 minutes and 46 seconds

So last version is faster with both engines. I don't know why this time it took just 7 minutes instead of 25 but now everything makes sense.

Thanks for your great kindness and sorry for making you waste time on something so silly.

Nicola