[#CORE-3079] Strong slowing down inserts with EVENT-s in a single transaction.

Firebird Core

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

Created: 26/Jul/10 04:42 AM Updated: 04/Feb/11 12:13 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

Time Tracking:

Not Specified

Environment:

« Hide

Kubuntu Linux 10.4 woth all updates
FirebirdSS-2.5.0.26038-ReleaseCandidate3.i686.tar.gz

Issue Links:

Duplicate

This issue is duplicated by:

~~CORE-3095~~ Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction

Relate

This issue is related to:

~~CORE-2634~~ Performance regression when restoring database with big metadata

Planning Status:

Unspecified

Description

« Hide

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

Discussion: http://groups.google.ru/group/ru-firebird/browse_thread/thread/17d304dadd7834a1
<rus>
При массовой загрузки данных в базу скорость
последовательности инсертов уменьшается на 1/6 если все они в одной
транзакции.
На таблице висит триггер генерирующий EVENT на каждый insert
Если триггер отключить, скорость инсертов остаётся постоянной.
</rus>

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 26/Jul/10 10:56 AM

Bug was introduced within patch for ~~CORE-2634~~

[ Permalink | « Hide ]

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"?

[ Permalink | « Hide ]

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.