Re: More on web application performance with DBI

1999-10-29 Thread gangadharan narayan
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 in

Re: More on web application performance with DBI

1999-10-29 Thread Michael Peppler
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 Bunce

Re: More on web application performance with DBI

1999-10-29 Thread Michael Peppler
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 doing that?

Re: More on web application performance with DBI

1999-10-18 Thread Tim Bunce
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/second

Re: More on web application performance with DBI

1999-10-15 Thread Matt Sergeant
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

Re: More on web application performance with DBI

1999-10-15 Thread Michael Peppler
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 Stage 2 (bound parameters): 139.20 requests/second Stage 3 (persistent statement handles): 251.13 requests

Re: More on web application performance with DBI

1999-10-14 Thread Tim Peoples
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 statement

Re: More on web application performance with DBI

1999-10-14 Thread Perrin Harkins
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

Re: More on web application performance with DBI

1999-10-14 Thread Jeffrey W. Baker
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 I know

Re: More on web application performance with DBI

1999-10-14 Thread Jeffrey W. Baker
"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 statement handles):

Re: More on web application performance with DBI

1999-10-14 Thread Oleg Bartunov
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 application performance with DBI On Thu