mysql 5.5.9 dreadfully slow

[nick rulez]

Hi. I'm trying for the first time mysql 5.5.9 on my notebook packard bell easynote tm86 and I'm very disappointed.

This in an example:

create table people(
id int not null auto_increment primary key,
`dob` date
);

delimiter //
drop procedure if exists date_random //
create procedure date_random(in low date,in upp date,in number int)
begin
declare i int default 0;
while i < number do
    begin
    insert into people (`dob`)  values ( low + interval rand()* datediff(upp,low) day  );
    set i = i + 1;
    end;
end while;
end //
delimiter ;

call date_random('1910-01-01',curdate(),500000);

This sp on mysql 5.1.36 takes about 25 seconds.
On mysql 5.5.9 the same procedure takes 25 minutes and 26 seconds.
I was trying even some slow query that I had to see if they run better in the last version. Unluckily they are even slower.

Has anyone had the same problem?
Thanks for any opinion.



Edited 1 time(s). Last edit at 02/20/2011 07:27PM by nick rulez.