Re: DBIX::Class and transactions

I'm not a die-hard DBIx::Class expert, so take my statement with a grain of salt.

... but I don't see a reason not to use:

while (things_to_process) {
   $schema->txn_do(sub {
       # insert your 1000 rows here
   });
}
[download]

Perl 6 - second systems done right

Comment on Re: DBIX::Class and transactions Download Code

Replies are listed 'Best First'.
Re^2: DBIX::Class and transactions by learnedbyerror (Monk) on Jul 14, 2011 at 11:28 UTC
I apologize for not updating this in a more timely manner. I have been using txn_do and this works well as long long as my transactions are not too big and not in too large of a volume. However, I am not satisfied with its performance for larger transactions or transactions with larger volumes as I have not been able to identify get this to work with parallel transactions (threaded or forked) with SQLite. I will start a new thread with more information on this.	[reply]

Replies are listed 'Best First'.

Re^2: DBIX::Class and transactions
by learnedbyerror (Monk) on Jul 14, 2011 at 11:28 UTC

I apologize for not updating this in a more timely manner. I have been using txn_do and this works well as long long as my transactions are not too big and not in too large of a volume. However, I am not satisfied with its performance for larger transactions or transactions with larger volumes as I have not been able to identify get this to work with parallel transactions (threaded or forked) with SQLite. I will start a new thread with more information on this.

[reply]