Issue Details (XML | Word | Printable)

Key: CORE-3079
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Alexandr N. Zamaraev
Votes: 0
Watchers: 2

If you were logged in you would be able to see more operations.
Firebird Core

Strong slowing down inserts with EVENT-s in a single transaction.

Created: 26/Jul/10 04:42 AM   Updated: 18/Jan/16 05:18 PM
Component/s: Engine
Affects Version/s: 2.5 RC2, 2.5 RC3
Fix Version/s: 2.5.0, 2.1.4, 3.0 Alpha 1

Kubuntu Linux 10.4 woth all updates
Issue Links:

QA Status: No test

 Description  « Hide
When bulk loading data into a speed
sequence of inserts is reduced by 1 / 6 if they are all in one
On the table hangs a trigger generates EVENT for each insert
If the trigger is disabled, the rate of inserts is constant.

При массовой загрузки данных в базу скорость
последовательности инсертов уменьшается на 1/6 если все они в одной
На таблице висит триггер генерирующий EVENT на каждый insert
Если триггер отключить, скорость инсертов остаётся постоянной.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 26/Jul/10 10:56 AM
Bug was introduced within patch for CORE-2634

Sean Leyne added a comment - 26/Jul/10 03:05 PM
I'd like to edit the entry description to be more descriptive. Would it be correct to re-pharse the issue as: "INSERT operations significantly slowed if EVENTs raised"?

Vlad Khorsun added a comment - 26/Jul/10 06:51 PM
In fact any on-commit work could lead to such slowdown. I didn't verified but will not wonder if long DDL scripts running with AUTODDL set to OFF will run slowly without this patch.