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-issue-importer opened this issue Jul 26, 2010 · 10 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 26, 2010

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 26, 2010

Modified by: @hvlad

Link: This issue is related to CORE2634 [ CORE2634 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 26, 2010

Commented by: @hvlad

Bug was introduced within patch for CORE2634

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 26, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 26, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 26, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 3, 2010

Modified by: @hvlad

Link: This issue is duplicated by CORE3095 [ CORE3095 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 2, 2010

Modified by: @dyemanov

Fix Version: 2.5.0 [ 10221 ]

Fix Version: 2.5.1 [ 10333 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 4, 2011

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 18, 2016

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
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants