I'd like to have multiple ithreads share a single db connection. The DBD::mysql doc seems to indicate there wouldn't be an issue, but the DBI doc still indicates that is a no go to use a shared connection.
"However, the internal pointer data within the handles will refer to the DBI and drivers in the original interpreter. Using those handles in the new interpreter thread is not safe, so the DBI detects this and croaks on any method call using handles that don't belong to the current thread (except for DESTROY). Because of this (possibly temporary) restriction, newly created threads must make their own connections to the database. Handles can't be shared across threads. " using perl 5.8.8, DBI 1.609, DBD::mysql 4.011 mysql 5.0.45-log Is this restriction still needed / enforced? -- Tim Hester Impeva Labs, Inc. O: 850-872-7099 C: 850-832-4216 COMPANY CONFIDENTIAL NOTICE This electronic mail transmission and any accompanying documents contain information belonging to the sender which may be company confidential and legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or action taken in reliance on the message is strictly prohibited. If you have received this message in error, please delete it. Thank You.