Re: [RDBO] insert speed questions with RDBO

2008-01-24 Thread Ted Zlatanov
On Wed, 23 Jan 2008 16:20:48 -0500 "John Siracusa" <[EMAIL PROTECTED]> wrote: JS> On Jan 23, 2008 2:07 PM, Ted Zlatanov <[EMAIL PROTECTED]> wrote: >> I found one of the problems is that you forcibly set RaiseError to 1 in >> a lot of places, in Rose::DB and Rose::DB::Object. Why override the >>

Re: [RDBO] insert speed questions with RDBO

2008-01-23 Thread John Siracusa
On Jan 23, 2008 2:07 PM, Ted Zlatanov <[EMAIL PROTECTED]> wrote: > I found one of the problems is that you forcibly set RaiseError to 1 in > a lot of places, in Rose::DB and Rose::DB::Object. Why override the > connect_options? > > My code is working with do_transaction for now, but begin_work/com

Re: [RDBO] insert speed questions with RDBO

2008-01-23 Thread Ted Zlatanov
On Tue, 22 Jan 2008 20:09:55 -0500 "John Siracusa" <[EMAIL PROTECTED]> wrote: JS> On Jan 22, 2008 11:42 AM, Ted Zlatanov <[EMAIL PROTECTED]> wrote: >> I'd like to try without autocommit; I tried the built-in RDBO >> transactions but those didn't work well for me. begin_work was fine, >> but if a

Re: [RDBO] insert speed questions with RDBO

2008-01-22 Thread John Siracusa
On Jan 22, 2008 11:42 AM, Ted Zlatanov <[EMAIL PROTECTED]> wrote: > I'd like to try without autocommit; I tried the built-in RDBO > transactions but those didn't work well for me. begin_work was fine, > but if an error happened anywhere in the transaction, rollback() didn't > do anything and the D

Re: [RDBO] insert speed questions with RDBO

2008-01-22 Thread Ted Zlatanov
On Mon, 07 Jan 2008 12:34:16 -0600 Ted Zlatanov <[EMAIL PROTECTED]> wrote: TZ> On Sat, 5 Jan 2008 15:27:34 -0500 "John Siracusa" <[EMAIL PROTECTED]> wrote: JS> On Jan 5, 2008 1:25 PM, Ted Zlatanov <[EMAIL PROTECTED]> wrote: >>> I realize much of this question belongs to database-specific domain

Re: [RDBO] insert speed questions with RDBO

2008-01-07 Thread Ted Zlatanov
On Sat, 5 Jan 2008 15:27:34 -0500 "John Siracusa" <[EMAIL PROTECTED]> wrote: JS> On Jan 5, 2008 1:25 PM, Ted Zlatanov <[EMAIL PROTECTED]> wrote: >> I realize much of this question belongs to database-specific domains, >> but here goes: I want RDBO insert operations to be faster. I need to >> loa

Re: [RDBO] insert speed questions with RDBO

2008-01-07 Thread Ted Zlatanov
On Sat, 05 Jan 2008 14:07:05 -0500 Adam Prime <[EMAIL PROTECTED]> wrote: AP> Ted Zlatanov wrote: >> I realize much of this question belongs to database-specific domains, >> but here goes: I want RDBO insert operations to be faster. I need to >> load thousands of records per second into a databas

Re: [RDBO] insert speed questions with RDBO

2008-01-05 Thread John Siracusa
On Jan 5, 2008 1:25 PM, Ted Zlatanov <[EMAIL PROTECTED]> wrote: > I realize much of this question belongs to database-specific domains, > but here goes: I want RDBO insert operations to be faster. I need to > load thousands of records per second into a database. The first thing to investigate is

Re: [RDBO] insert speed questions with RDBO

2008-01-05 Thread Adam Prime
Ted Zlatanov wrote: > I realize much of this question belongs to database-specific domains, > but here goes: I want RDBO insert operations to be faster. I need to > load thousands of records per second into a database. I'm using > PostgreSQL, and everything works correctly. The extra DB operatio

[RDBO] insert speed questions with RDBO

2008-01-05 Thread Ted Zlatanov
I realize much of this question belongs to database-specific domains, but here goes: I want RDBO insert operations to be faster. I need to load thousands of records per second into a database. I'm using PostgreSQL, and everything works correctly. The extra DB operations per insert are killing pe