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
Comments
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Modified by: @hvladstatus: 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 ] |
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"? |
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. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
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
The text was updated successfully, but these errors were encountered: