The source data comes from 3 mysql-databases, residing on the same server. There are quite heavy load on them already, which means that there might be quite slow access to them. And, theres quite much data that is to be exported. So, to gain some time I want to fetch data from them in parallell, using multiple database-handles (Possibly, I will end up with the same end time since the data resides on the same server, what do you think?)

My thought here was to dump the data to file as quick as possible so that the server could keep as little data in memory as possible (of course there can be a possibility that my current "way" of using xml::writer isn't memory effective, who knows). So yes, I want to fetch the data in parallell and write it to the output file.

In reply to Re^4: Multithreaded xml writing using XML::Writer by DreamT
in thread Multithreaded xml writing using XML::Writer by DreamT

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.