[ZBXNEXT-2285] API create and update optimization Created: 2014 Apr 29 Updated: 2022 Sep 09 Resolved: 2022 Sep 06 |
|
| Status: | Closed |
| Project: | ZABBIX FEATURE REQUESTS |
| Component/s: | API (A) |
| Affects Version/s: | 2.3.0 |
| Fix Version/s: | None |
| Type: | Change Request | Priority: | Trivial |
| Reporter: | Ivo Kurzemnieks | Assignee: | Unassigned |
| Resolution: | Unsupported version | Votes: | 0 |
| Labels: | api, improvements, optimization | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
API create and update methods check existing names in each foreach iteration. This means a separate SQL query is executed for each name. We can optimize this to query existing names all at once. Partially this has been done in |
| Comments |
| Comment by Ivo Kurzemnieks [ 2022 Sep 06 ] |
|
In newer versions the mentioned APIs have already improved validation for create and update methods. There are no loops when finding duplicate names. |