Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re: ?Thread safe DBI? any updates?

by sundialsvc4 (Abbot)
on Feb 15, 2013 at 19:06 UTC ( #1018946=note: print w/replies, xml ) Need Help??

in reply to ?Thread safe DBI? any updates?

If you are going to multi-thread queries, also check that query processing actually does occur in parallel.   This would not only mean that the queries are being effectively handled as separate streams, but also that the queries themselves are capable of executing without contention with one another .. transaction isolation and so-forth.   And that it is actually faster, given what you are actually trying to do and actual conditions.

Lately, I have switched more-and-more to simple programs that can be run independently of one another, i.e. as entirely separate processes, launched for example through a batch or workload-processing system.   With this approach, there is of course no concurrency-issue within the application that must be considered, and the workload manager can tune the situation very directly:   just launch as many copies as you need.   Naturally you have to have a reliable and not-too contentious way to parcel up the work.

Replies are listed 'Best First'.
Re^2: ?Thread safe DBI? any updates?
by BrowserUk (Pope) on Feb 15, 2013 at 20:43 UTC
    Lately, I have switched more-and-more to simple programs

    Care to post one of those simple programs? Or one of the threaded programs it replaces?

    Or indeed, post any single piece of runnable code by which we might collectively gauge the efficacy of the coding prowess that sits behind your home-brew wisdom?

    Because on the strength of the utter guff you repeatedly spew into any and every thread on threading; I seriously doubt that you have ever written a threaded program in your life. To date, you have yet to post a single code solution, on any subject, anywhere on this forum. You are a fantasist. Nothing more nor less.

    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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1018946]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (7)
As of 2018-06-21 10:50 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (118 votes). Check out past polls.