Re: Parallel::ForkManager && DBI memory leak ?

From: Cosimo Streppone (cstreppone_at_team2k.net)
Date: 12/29/04

  • Next message: Chris Denman: "Re: Problem with "while/fetchrow_array"" 
    Date: Wed, 29 Dec 2004 19:08:27 +0100
To: "Follett, Robert" <robert.follett@Vanderbilt.Edu>

    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, Parallel::ForkManager starts up a
    new process (`$pm->start()') that *must* take care of (re)connecting
    to database, because AFAIK DBI handles will not stay shared
    among different processes. 

    -- 
Cosimo
  • Next message: Chris Denman: "Re: Problem with "while/fetchrow_array""

    Relevant Pages

    • Re: Antenna Replacement Experiment
      ... There may be different rules for connecting external antennas depending on ... if the objective is to get max gain or to get strongest null response. ... If the objective of the loop is to null out a specific frequency, ... I hope you try this antenna modification and report the results ...
      (rec.radio.amateur.antenna)
    • Re: How to rebuild SQL connection
      ... I think neilphan's suggestion on use a Try-catch block to protect the ... loop to try connecting that server for several times before you abort ... controls when to abort a connecting operation after certain period of time ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Connect to access database
      ... never user On Error Resume Next in my scripts, so there is no worry there ... So its either not connecting or my logic is screwed up. ... you are selecting all records from the INVENTORY table. ... A Do Loop (with a "oRS.MoveNext"! ...
      (microsoft.public.scripting.wsh)
    • Re: DOS MODE command patch for CTTY w/o CTS / DSR ?
      ... You are connecting two computers together, ... "RS232 null modem with loop back handshaking" here: ... and more "RS232 null modem with loop back handshaking" here: ...
      (comp.os.msdos.djgpp)
    • Re: Wellbrook question
      ... Given the almost sacred refference the Wellbrook is held in I have ... This antenna is reputed to be the cat's meow, ... One thing you might do is check the cables connecting the different ... At one point I noticed that my loop wasn't ...
      (rec.radio.shortwave)