Re: DBI Threaded use access?

2012-10-11 Thread Tim Bunce 
On Wed, Oct 10, 2012 at 06:32:54PM -0700, Chris Buxton wrote:
 On Oct 10, 2012, at 1:21 PM, Jack Craig wrote:
 
  Hi DBI-Users,
  
  I have a simple Perl program to open a file, db, serially read file, write
  file records to db, close db, close file.
  
  if, between the db open  close, given a single dbh, i create multiple
  threads, each
  reading a segment of the file and asynchronously writing to db using the
  same dbh,
  is that ok?
 
 No. Each thread needs its own dbh. Your DBD may not support this.

Specifically, 
http://search.cpan.org/~timb/DBI-1.622/DBI.pm#Threads_and_Thread_Safety

Tim.

Re: DBI Threaded use access?

2012-10-11 Thread Chris Buxton 

On Oct 11, 2012, at 8:15 AM, Tim Bunce wrote:

 On Wed, Oct 10, 2012 at 06:32:54PM -0700, Chris Buxton wrote:
 On Oct 10, 2012, at 1:21 PM, Jack Craig wrote:
 
 Hi DBI-Users,
 
 I have a simple Perl program to open a file, db, serially read file, write
 file records to db, close db, close file.
 
 if, between the db open  close, given a single dbh, i create multiple
 threads, each
 reading a segment of the file and asynchronously writing to db using the
 same dbh,
 is that ok?
 
 No. Each thread needs its own dbh. Your DBD may not support this.
 
 Specifically, 
 http://search.cpan.org/~timb/DBI-1.622/DBI.pm#Threads_and_Thread_Safety

Another possibly useful resource on this topic can be found here:

http://search.cpan.org/~darnold/DBIx-Threaded-0.10/lib/DBIx/Threaded.pm

Looks good for DBDs that aren't reentrant. I haven't tried it myself.

Chris Buxton
BlueCat Networks