Re^2: DBI mysql insert into select speed :-/

I've fiddled with threads before and it all ended in tears.

Not that I want my script to do anything during the query anyway. Just want it a bit faster, it's taking 10s to finish at the minute.

Comment on Re^2: DBI mysql insert into select speed :-/

Replies are listed 'Best First'.
Re^3: DBI mysql insert into select speed :-/ by moritz (Cardinal) on Jun 04, 2008 at 21:56 UTC
You're basically telling us that you have slow SQL, that we shouldn't tell you to get the indexes right, and that it's too slow. And you don't show us any SQL that we could help you to improve. And the problem doesn't seem to have a connection to perl at all, because it's that database that's slow, not perl. So what do you expect us to do? Should we say "just add the --fast option to the mysql server"? Sorry, there is no silver bullet to speed things up (unless buying better hardware, of course).	[reply]

Replies are listed 'Best First'.

Re^3: DBI mysql insert into select speed :-/
by moritz (Cardinal) on Jun 04, 2008 at 21:56 UTC

You're basically telling us that you have slow SQL, that we shouldn't tell you to get the indexes right, and that it's too slow. And you don't show us any SQL that we could help you to improve. And the problem doesn't seem to have a connection to perl at all, because it's that database that's slow, not perl.

So what do you expect us to do? Should we say "just add the --fast option to the mysql server"?

Sorry, there is no silver bullet to speed things up (unless buying better hardware, of course).

[reply]