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.
