in reply to dbi & threads

If your hope is to cut the overall query time by issuing multiple concurrent queries to your DB, it it very unlikely to suceed even if you work around the problem of sharing DBI handles. Multiple queries to a given database will usually be serialised by the DBM at the server end.

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
Lingua non convalesco, consenesco et abolesco. -- Rule 1 has a caveat! -- Who broke the cabal?
"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: dbi & threads
by renodino (Curate) on Jul 08, 2006 at 15:47 UTC
    ...not to mention that MSSQL (or maybe its ODBC driver ?) doesn't seem to support multiple open requests on a single connection (a problem I recently encountered and had to workaround in DBIx::Chart).

    I'll inject an obligatory plug for DBIx::Threaded here, but it likely (a) wouldn't work with Class::DBI and (b) would just serialize the query processing on the client side.

[reply]

In Section Seekers of Perl Wisdom