in reply to Re: DBI mysql insert into select speed :-/
in thread DBI mysql insert into select speed :-/

Thanks for that,

My concern was about seeing 'sending data', which to me implies that the query has finished and mysql is now sending the results back to Perl space.

Doing an INSERT INTO ... SELECT with a do() shouldn't send anything back, or should it?
  • Comment on Re^2: DBI mysql insert into select speed :-/

Replies are listed 'Best First'.
Re^3: DBI mysql insert into select speed :-/
by perrin (Chancellor) on Jun 04, 2008 at 22:57 UTC
    No, that won't send data to Perl other than whether or not the query succeeded. It's doing something else during that time, possibly copying the results into your new table.