in reply to multi threading DBI

i want to upgrade the script to a multithreaded one, but DBI does not support multithreading... what should i do?

Do your scraping from multiple threads and use a single separate thread to do the DBI stuff.

Have the scraping threads post the data to be entered into the DB, to the DBI thread -- as plain text -- via a queue.

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.

Replies are listed 'Best First'.
Re^2: multi threading DBI
by Anonymous Monk on Oct 29, 2013 at 17:45 UTC
    Can u kindly point me to any example code for this thread::queue? i am very new to threads...
[reply]

      Take your pick

      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.
[reply]

In Section Seekers of Perl Wisdom