in reply to Re^3: Remote database and process
in thread Remote database and process

Hi, I wonder if POE::Component::DBIAgent - POE Component for running asynchronous DBI calls is efficient to do? Please sugguest.

Replies are listed 'Best First'.
Re^5: Remote database and process
by BrowserUk (Patriarch) on Jun 07, 2010 at 08:42 UTC

    If a single DBI query returns (and caches) sufficient data to cause you to have memory problems in a stand-alone process; running multiple concurrent queries via POE (or anything else isn't going to prevent that problem from occuring.

    The --quick option of the mysql command is specifically designed to return query results row by row rather than accumulating them all in memory and returning them en-masse. Hence my suggestion to use that.


    Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
    "Science is about questioning the status quo. Questioning authority".
    In the absence of evidence, opinion is indistinguishable from prejudice.