in reply to Re^3: How to use threads to write worksheets of excel
in thread How to use threads to write worksheets of excel

Nice++ BrowserUk. Closing Excel::Writer::XLSX is time consuming. Your demonstration does that in parallel which is beneficial for millions of rows.

  • Comment on Re^4: How to use threads to write worksheets of excel

Replies are listed 'Best First'.
Re^5: How to use threads to write worksheets of excel
by BrowserUk (Patriarch) on Jul 01, 2015 at 22:50 UTC

    Probably the most important thing in my demo code for efficiency is: $wb->set_optimization();.

    With it, the xml gets written on the fly; without it, the whole thing gets accumulated in memory and written as a big spew on close


    With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
    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.
    I'm with torvalds on this Agile (and TDD) debunked I told'em LLVM was the way to go. But did they listen!