Question 1: How man callers will DBI Proxy hold in queue ? Question 2: Is there any kind of probable timeframe for Perl 5.8 ?
Karyn -----Original Message----- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 8:07 AM To: Roland Lammel; Ives, Larry Cc: [EMAIL PROTECTED] Subject: RE: multi-threaded DBI Proxy on NT 4.0 You might try a commercial product from EasySoft (www.easysoft.com) or OpenLink (www.openlinksw.com). They may have multi-threaded access built in. (Note, I do not represent either company, rather I just have used their products to test DBD::ODBC on Linux). I haven't tried multiple user access, though. Jeff > > 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 > ------------------------------------- >
