Re: Slow connection

On Fri, Jun 07, 2002 at 04:39:53PM +0200, Arthur wrote:

> I can outline the basic logic of the program, maybe you can pick
> something up. I query a table and process the rows. For each row an
> update statement is run that updates data in the processed row. I
> use a persistant connection for the updates, but I'm not keen to do
> transaction batches wtih commit/rollback, etc.

Are you quite sure you're not in a transaction?  Because given that
you're doing updates, and everyone else is apparently blocked, I'd
expect you're holding a lock on data they're trying to read.  Update
causes a very aggressive lock, for obvious reasons.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110