[Zope-DB] Re: update table

Dmitry Matveev Dmitry Matveev <matveev@prime.ru>
Fri, 4 Apr 2003 10:31:53 +0600

MG> You give very little information about your special problem,
Z Psycopg Database Connection is used
Postgres 7.3
Zope Version  (Zope 2.6.0 (source release, python 2.1, linux2), python 2.1.3, linux2)
Python Version  2.1.3 (#1, Nov 22 2002, 11:00:13) [GCC 2.95.4 20011002 (Debian prerelease)]  

More then 200 sql queries are used wnen page rendering, one of them
UPDATE  and othes are INSERT. The page renders 1,5 sec  and the
problem of concurent update is rased due to zope transaction. And
using: try-except can't help.

I solve the problem by using
one  Database Connection for INSERTs and another for update.

Best regards,                          www.uralfirm.ru
Dmitry Matveev                         mailto:matveev@uralfirm.ru