[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