in reply to how can N client.pl connect to one deamon serving mysql

This is the guide to speed. I'm afraid you did not use placeholders, prepare() and execute.

On the other hand: Is DBI the right tool for the job? Mass inserts (as you seem to be doing) are best left to the LOAD DATA command. Maybe you ftp the files over and have the daemon insert them locally.

  • Comment on Re: how can N client.pl connect to one deamon serving mysql

Replies are listed 'Best First'.
Re^2: how can N client.pl connect to one deamon serving mysql
by Anonymous Monk on Feb 23, 2006 at 20:30 UTC
    hmm.. problem is - the next stage will be a bidirectional communication, because i need the lastinsertid.

    i already switched back from INSERT DELAYED to plain INSERT. like i just posted, it works in a way :-)

    if i can handle the local connections in a multithreaded style, a "usual" db_connect should also be possible... i think...