Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-913

Encapsulate mass DML instructions into transactions

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Minor
    • Resolution: Won't fix
    • 1.6
    • None
    • None
    • None
    • PostgreSQL, version-indep

    Description

      On mass updates/insert (like items of a host, or so), the updates should be encapsulated into a single transaction (wikipedia has good materials on DB transactions, if you don't know what are them). This will increase performance more the a lot. If you don't know why, i suggest reading any relevant books or papers on database engineering and/or designing. Having mass DML instructions encapsulated into a single transaction is an essential for such a big application.

      Attachments

        Activity

          People

            alexei Alexei Vladishev
            phoemix Gergely Czuczy
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: