Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
firebird-automations opened this issue Jul 26, 2010 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @tonal

Is related to CORE2634
Is duplicated by CORE3095

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>

Commits: 851b74c 21bf6b8 4495a7c

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue is related to CORE2634 [ CORE2634 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Bug was introduced within patch for CORE2634

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1.4 [ 10361 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.5.1 [ 10333 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue is duplicated by CORE3095 [ CORE3095 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.5.0 [ 10221 ]

Fix Version: 2.5.1 [ 10333 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment