Greg Stark wrote:
>
>*** From dbi-users - To unsubscribe, see the end of this message. ***
>*** DBI Home Page - http://www.symbolstone.org/technology/perl/DBI/ ***
>
> Tim Bunce <[EMAIL PROTECTED]> writes:
> > On Mon, Oct 18, 1999 at 07:08:09AM -0700, Michael Peppler wrote:
> > > Tim B
Hi ,
I have a perl script which connects to the
oracle database. I want to know if i can lock the
script. i.e even if there are many requests to the
server for the same script there will be no
concurrency & update problems.
Also how i implement commit & rollbacks in a script.
thanks for help i
Greg Stark writes:
> Michael Peppler <[EMAIL PROTECTED]> writes:
>
> > Greg Stark wrote:
> >
> > Actually not - Sybase creates a temporary stored proc for each prepared
> > statement, so it's equivalent to using stored procedures.
>
> Heh neat, is that DBD::Sybase or the server that's do
> > Actually not - Sybase creates a temporary stored proc for each prepared
> > statement, so it's equivalent to using stored procedures.
>
> Heh neat, is that DBD::Sybase or the server that's doing that?
> And does it only work for a single statement handle or does it keep
> that procedure around
Michael Peppler <[EMAIL PROTECTED]> writes:
> Greg Stark wrote:
>
> Actually not - Sybase creates a temporary stored proc for each prepared
> statement, so it's equivalent to using stored procedures.
Heh neat, is that DBD::Sybase or the server that's doing that?
And does it only work for a singl
Tim Bunce <[EMAIL PROTECTED]> writes:
> On Mon, Oct 18, 1999 at 07:08:09AM -0700, Michael Peppler wrote:
> > Tim Bunce writes:
> > > On Fri, Oct 15, 1999 at 11:42:29AM +0100, Matt Sergeant wrote:
> > > > Sadly prepare_cached doesn't always work very well - at least not with
> > > > Sybase (and
On Tue, 19 Oct 1999, Tim Bunce wrote:
> If the ``$sth->fetchall_arrayref if $sth->{Active};'' logic was
> added to the DBI's prepare_cached, wouldn't that be enough for you?
> (Assuming you call prepare_cached for the first time for each
> statement when there's no active statement handle.)
I don
On Tue, Oct 19, 1999 at 12:36:30PM +0100, Matt Sergeant wrote:
> On Mon, 18 Oct 1999, Tim Bunce wrote:
> > >
> > > I've never looked at prepare_cached() for DBD::Sybase, and Matt tried
> > > it out and it appeared not to work.
> >
> > "appeared not to work" isn't much more specific :-)
>
> Sorr
On Mon, 18 Oct 1999, Tim Bunce wrote:
> >
> > I've never looked at prepare_cached() for DBD::Sybase, and Matt tried
> > it out and it appeared not to work.
>
> "appeared not to work" isn't much more specific :-)
Sorry, but I don't have enough tuits to tie it down exactly. As Michael
said it's a
On Mon, Oct 18, 1999 at 07:08:09AM -0700, Michael Peppler wrote:
> Tim Bunce writes:
> > On Fri, Oct 15, 1999 at 11:42:29AM +0100, Matt Sergeant wrote:
> > > On Fri, 15 Oct 1999, Perrin Harkins wrote:
> > > > On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > > > > Zero optimization: 41.67 requests
Tim Bunce writes:
> On Fri, Oct 15, 1999 at 11:42:29AM +0100, Matt Sergeant wrote:
> > On Fri, 15 Oct 1999, Perrin Harkins wrote:
> > > On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > > > Zero optimization: 41.67 requests/second
> > > > Stage 1 (persistent connections): 140.17 requests/second
On Fri, Oct 15, 1999 at 11:42:29AM +0100, Matt Sergeant wrote:
> On Fri, 15 Oct 1999, Perrin Harkins wrote:
> > On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > > Zero optimization: 41.67 requests/second
> > > Stage 1 (persistent connections): 140.17 requests/second
> > > Stage 2 (bound parameters):
rey W. Baker [mailto:[EMAIL PROTECTED]]
> Sent: 15 October 1999 03:50
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: More on web application performance with DBI
>
>
> "Jeffrey W. Baker" wrote:
> >
> > Perrin Harkins wrot
, [EMAIL PROTECTED]
> > Subject: Re: More on web application performance with DBI
> >
> > On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > > Zero optimization: 41.67 requests/second
> > > Stage 1 (persistent connections): 140.17 requests/second
> > >
On Fri, 15 Oct 1999, Perrin Harkins wrote:
> On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > Zero optimization: 41.67 requests/second
> > Stage 1 (persistent connections): 140.17 requests/second
> > Stage 2 (bound parameters): 139.20 requests/second
> > Stage 3 (persistent statement handles): 251.13
], [EMAIL PROTECTED]
> > Subject: Re: More on web application performance with DBI
> >
> > On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > > Zero optimization: 41.67 requests/second
> > > Stage 1 (persistent connections): 140.17 requests/second
> > > Stag
On Thu, 14 Oct 1999, Perrin Harkins wrote:
> Date: Thu, 14 Oct 1999 17:53:15 -0700 (PDT)
> From: Perrin Harkins <[EMAIL PROTECTED]>
> To: Jeffrey Baker <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: More on web appli
"Jeffrey W. Baker" wrote:
>
> Perrin Harkins wrote:
> >
> > On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > > Zero optimization: 41.67 requests/second
> > > Stage 1 (persistent connections): 140.17 requests/second
> > > Stage 2 (bound parameters): 139.20 requests/second
> > > Stage 3 (persistent st
Perrin Harkins wrote:
>
> On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > Zero optimization: 41.67 requests/second
> > Stage 1 (persistent connections): 140.17 requests/second
> > Stage 2 (bound parameters): 139.20 requests/second
> > Stage 3 (persistent statement handles): 251.13 requests/second
>
On Thu, Oct 14, 1999 at 05:53:15PM -0700, Perrin Harkins wrote:
> On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > Zero optimization: 41.67 requests/second
> > Stage 1 (persistent connections): 140.17 requests/second
> > Stage 2 (bound parameters): 139.20 requests/second
> > Stage 3 (persistent state
On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> Zero optimization: 41.67 requests/second
> Stage 1 (persistent connections): 140.17 requests/second
> Stage 2 (bound parameters): 139.20 requests/second
> Stage 3 (persistent statement handles): 251.13 requests/second
I know you said you don't like it b
21 matches
Mail list logo
