Ticket #1 (closed enhancement: fixed)

Opened 4 years ago

Last modified 3 years ago

Insertion performance improvements

Reported by: tsnorri Owned by: tsnorri
Priority: major Milestone: Developer Preview 3
Component: BaseTen Keywords: performance
Cc:

Description

BaseTen is currently pretty slow on insertions, and without autocommit shared memory is exhausted quickly. The solution could be to offer an API which would allow user to combine several DB context (e.g. createObject) into a single undo block, so BaseTen wouldn't have to create a separate savepoint for each INSERT statement.

It is possible that the need for savepoint could be deduced from undo grouping level. This way, new API would not be needed.

Change History

Changed 4 years ago by tsnorri

  • milestone set to Developer Preview 2

Changed 4 years ago by markonen

  • milestone changed from Developer Preview 2 to Developer Preview 3

Changed 3 years ago by tuukka.norri@…

  • status changed from new to closed
  • resolution set to fixed

(In [111]) Undo enhancements and manual commit mode - BXDatabaseContext now tries to decide, when to create savepoints based on undo grouping level. Basically, if the level is greater than zero, a savepoint will only be created when the undo group gets closed (fixes #1). - Unfortunately, this hasn't been tested much. - Fixed some minor bugs (error -> localError etc.) - Also rewrote most of transaction handling in BXPGInterface (fixes #40).

Note: See TracTickets for help on using tickets.