Skip site navigation (1) Skip section navigation (2)

Re: ["Dean Arnold" <darnold@earthlink.net>] Re: Array Binding Status?

From: "Jason E(dot) Stewart" <jason(at)openinformatics(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: ["Dean Arnold" <darnold@earthlink.net>] Re: Array Binding Status?
Date: 2002-12-11 07:21:50
Message-ID: 87d6o9qaup.fsf@openinformatics.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,

I never heard back about this.

Does anyone know if the postgres C API and the server backend have the
ability to handle this?

Thanks,
jas.

"Jason E. Stewart" <jason(at)openinformatics(dot)com> writes:

> Hi all,
> 
> I'm included a piece of a discussion that was had on the Perl DBI
> mailing list a while back. A new feature was added that enable
> applications to pass off arrays of placeholder values for each
> placeholder in a prepared SQL statement instead of only a single value
> for each placeholder.
> 
> This meant a significant speed-up for things like large INSERT
> statements.
> 
> My question is does Postgres have the necessary abilities to handle
> this feature?
> 
> Thanks ahead of time,
> jas.
> 
> From: "Dean Arnold" <darnold(at)earthlink(dot)net>
> Subject: Re: Array Binding Status?
> To: "DBI-dev" <dbi-dev(at)perl(dot)org>, Andrew_Brown(at)adc(dot)com,
>   "Jason E. Stewart" <jason(at)openinformatics(dot)com>,
>   "Jeff Urlwin" <jurlwin(at)bellatlantic(dot)net>
> Date: Fri, 8 Mar 2002 07:08:35 -0800
> 
> > > Thanks Andrew,
> > > 
> > > The question isn't whether the current DBD::Pg supports the behavior,
> > > it doesn't, the issue is whether the Postgres C API has an ability to
> > > do these array-based inserts.
> > > 
> > > I would definately have to modify DBD::Pg's C code to support this. 
> > > 
> > > I was just wondering from Dean and Jeff what kind of C API methods did
> > > they need to use to get it working for ODBC.
> > 
> > It's all part of the ODBC spec/API. 
> > 
> > Jeff
> > 
> 
> Or check the Oracle OCI array binding (the function names
> escape me at the moment).
> 
> The deeper issue is whether the DBMS supports a bulk
> operation, esp in a transactional context. E.g., Teradata
> has bulk operation utilities ala SQLLoader, but
> currently doesn't support bulk operations in a
> regular SQL connection. 
> 
> While adding an iterative
> query execution into the C API code will help some,
> the big boosts occur when the DBMS can gobble
> up a stream of 1,000+ placeholder tuples at once
> (and esp. for INSERT, dump 'em directly to disk),
> as e.g. Oracle and DB2 do.
> 
> Dean
> 
> 
> 
> ----------
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

pgsql-interfaces by date

Next:From: Godson RetnaDate: 2002-12-11 13:25:53
Subject: Re: FATAL 1: Password authentication failed
Previous:From: Godson RetnaDate: 2002-12-11 06:40:25
Subject: Re: FATAL 1: Password authentication failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group