MySQL Forums
Forum List  »  Perl

Performance with fork and Perl's DBI
Posted by: Matthew Fong
Date: February 17, 2006 03:37PM

I have an application that forks to handle requests.

I've read through several web documents claiming that I cannot share the same connection between the forked processes and that the correct way to handle this is to create a New DBI class within each child fork.

Each of my fork processes only do a single, very simple query. It seems highly ineffiecient that I perl must close and open a new mysql DB connection for each fork. My program performs at least 50+ forks a second.

Does DBI have some internal way of performacing turning and using some sort of persistent connection sharing? Are there any work arounds, and what are my options. Thanks.


Options: ReplyQuote

Written By
Performance with fork and Perl's DBI
February 17, 2006 03:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.