Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Ing. Branislav Gerzo
Hi pals, this is my first post to this mailing list. I have one problem, it is maybe for you small, but for me a big problem. If I want improve my scripts I _have_ to use parallel DB access. When I looked around I come to Parallel::ForkManager module, easy to use. When I wrote script, I saw it

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Thilo Planz
Hello, this is my first post to this mailing list. I have one problem, it is maybe for you small, but for me a big problem. If I want improve my scripts I _have_ to use parallel DB access. When I looked around I come to Parallel::ForkManager module, easy to use. I do not know Parallel::ForkManager

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Ing. Branislav Gerzo
Moosmann, James [MJ], on Wednesday, December 29, 2004 at 07:07 (-0500) thoughtfully wrote the following: MJ I am really disappointed with Perl's lack of support for any reliable. MJ multithreaded behavior. I keep hoping it gets fixed. But I have waited for MJ 2 years. ahm, I wrote some posts

RE: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Follett, Robert
You will get much better performance by connecting once, outside your foreach loop as well as disconnecting and finishing after the loop. Also read up on prepare_cached using bind params. You will want to prepare outside your foreach as well. The only thing you need to do inside your loop is

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Ron Wingfield
: Thursday, December 30, 2004 2:36 AM Subject: Parallel::ForkManager DBI memory leak ? Hi pals, this is my first post to this mailing list. I have one problem, it is maybe for you small, but for me a big problem. If I want improve my scripts I _have_ to use parallel DB access. When I looked

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Cosimo Streppone
Follett, Robert wrote: You will get much better performance by connecting once, outside your foreach loop as well as disconnecting and finishing after the loop. Having tried this, I can assure you that connecting *inside* the loop is the only alternative here. In fact, for every loop iteration,

Re: Parallel::ForkManager DBI memory leak ?

2004-12-29 Thread Ing. Branislav Gerzo
Ron Wingfield [RW], on Wednesday, December 29, 2004 at 10:29 (-0600) wrote the following: RW I know my comments do not provide an immediate solution, but RW this could be a very interesting thread.  Infact, I'm going to be RW writing some IPC intensive code in the near future, and I want to RW