Roundup Tracker - Issues

Issue 2551144

classification
Use subtransactions for error handling during roundup import??
Type: resource usage Severity: normal
Components: Database Versions: 2.2.0
process
Status: fixed fixed
:
: : rouilj
Priority: :

Created on 2021-06-13 19:42 by rouilj, last changed 2022-11-25 04:21 by rouilj.

Messages
msg7282 Author: [hidden] (rouilj) Date: 2021-06-13 19:42
in issue2551142, I "fixed" the problem by committing after every row in 
the csv import was created. This has performance implications.

Implementing this using subtransactions in posgresql:

  https://postgres-
py.readthedocs.io/en/latest/#postgres.Postgres.get_cursor

may allow us to solve the initial issue without having to
perform a per-row commit.

I am not sure how this interacts with the python DBI standard and how 
roundup interacts with the database, but it is worth a look.
msg7679 Author: [hidden] (rouilj) Date: 2022-11-25 04:21
fix prior to 2.2.0 release in

changeset:   6610:db3f0ba75b4a
date:        Sat Jan 29 11:29:36 2022 -0500
History
Date User Action Args
2022-11-25 04:21:52rouiljsetstatus: new -> fixed
resolution: fixed
messages: + msg7679
components: + Database
versions: + 2.2.0
2021-06-13 19:42:33rouiljcreate