Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-4941

Investigate Oracle bulk update performance

    XMLWordPrintable

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 48, Jan 2019, Sprint 49 (Feb 2019)
    • Story Points:
      2

      Description

      Zabbix uses DBbegin_multiple_update(), DBexecute_overflowed_sql() and DBend_multiple_update() functions to compile multiple SQL queries into single query. On Oracle using separate queries might be better because of query caching.

      Investigate performance difference on Oracle and if there are noticeable gains then change  DBexecute_overflowed_sql() to immediately execute the query instead of buffering it.

      Also review code where DBexecute_overflowed_sql() function is used. It's quite possible that in some places it's used after buffering mutiple queries - then the code must be changed to call it after each assembled query.

       

        Attachments

          Activity

            People

            Assignee:
            Kalimulin Alex Kalimulin
            Reporter:
            wiper Andris Zeila
            Votes:
            1 Vote for this issue
            Watchers:
            9 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: