[ZBXNEXT-4798] Separate media types into different tables Created: 2018 Oct 08  Updated: 2018 Oct 09

Status: Open
Project: ZABBIX FEATURE REQUESTS
Component/s: API (A), Frontend (F), Server (S)
Affects Version/s: 4.0.0
Fix Version/s: None

Type: Change Request Priority: Trivial
Reporter: Valdis Murzins Assignee: Alexander Vladishev
Resolution: Unresolved Votes: 0
Labels: mediatypes
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Different media types have different configuration fields that they use. Each such field uses one column in media types table. And already now we have columns that are used exclusively for one of media types, while is left empty for other. The number of unused fields will increase even more, when new media types will be added.

As a solution would be to have separate tables for different media types.



 Comments   
Comment by richlv [ 2018 Oct 08 ]

What would be the gain there?
If there is a notable gain, wouldn't items need it more, given how many fields are specific only for some item types?

Comment by Valdis Murzins [ 2018 Oct 09 ]

Thank you, richlv, you made the correct point.
I will leave this task to investigate the best solution and to prepare media types table for new media types with different configuration fields.

Generated at Tue Apr 23 18:55:45 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.