Hi, If you want to use multi-threaded processes you'll have to wait till 5.8.0 is released and ActiveState picks it up in their release. Then the modules for DBI have to be multi-thread aware, so after 5.8.0 Tim will probably release a DBI (along with DBI::Proxy) which should be able to run in threaded mode.
Till then your only choice on windows is to run more than 1 process and create a dispatcher which forwards to one of those (not forking, just handshake and tell a port to use). Cheers +rl "Ives, Larry" wrote: > > I am trying to find a way to run DBI Proxy as a multi-threaded application. > I have a linux box running RedHat with Apache. The DBI Proxy is running as a > server on the NT 4.0 box so it can broker the ODBC requests and pass them to > ODBC compliant databases. All is working well except that the DBI Proxy only > handles one request at a time and I'd like it to muti-thread instead. I am > using ActiveState Perl on the NT box and when I asked them about this their > response was as follows. Can anyone help me? > > Larry, > > Sorry for the delay in getting back to you, here's the comments on DBI-Proxy > from our Senior Perl Developer: > > There are two kinds of threads in perl. One is the older 5.005 > threads which is fundamentally broken and full of race conditions > (this should not be used in a production environment). The newer > one is ithreads which was introduced in Perl 5.6.0. DBI-Proxy only > supports the old broken 5.005 threads. We don't support 5.005 > threads because it has to be built a certain way that makes it > binary incompatible with ithreads, and we need ithreads to support > the fork() emulation. DBI-Proxy can also use fork() for > multi-processing, but this probably does not work with emulated fork() > on windows due to quirks of the fork() emulation. > > Unfortunately, DBI-Proxy will not work on Windows in anything > other than queued mode currently. Sorry. > > You may check DBI-Proxy with Perl 5.8.0 when it is released > (it has a threads module that should suffice). > > Larry, I hope this helps, please let me know if you have additional > questions. > > Regards, > > Jeff Chow, Enterprise Sales > ActiveState Corporation > http://www.ActiveState.com > Direct: 604.484.6486, 866.866.2802 > > Larry E. Ives > Database Projects Manager > Phone 281 874-2617 > Fax 281 874-2577 > Making Data Easily Accessible to the Right People > > ----- > If you are not the intended recipient of this message you are hereby > notified that any use, distribution or reproduction of this message is > prohibited. If you have received this message in error please notify > Swift Energy Company immediately. Any views expressed in this > message are those of the individual sender and may not necessarily > reflect the views of Swift Energy Company. -- +rl ------------------------------------- Roland Lammel ------------------------------------- Services / Technical Assistance / PPA Kapsch CarrierCom Triesterstr. 70a, 1102 Wien ------------------------------------- mailto:[EMAIL PROTECTED] Tel: +43 1 60501 - 3456 (ESN 572 3456) Fax: +43 1 60501 - 3405 Mobil: +43 664 628 - 3456 -------------------------------------
