[ZBXNEXT-2234] reduce the length of "units" field in "items" table Created: 2014 Mar 31 Updated: 2015 May 27 Resolved: 2015 May 26 |
|
| Status: | Closed |
| Project: | ZABBIX FEATURE REQUESTS |
| Component/s: | Installation (I) |
| Affects Version/s: | 2.2.2 |
| Fix Version/s: | None |
| Type: | Change Request | Priority: | Minor |
| Reporter: | Aleksandrs Saveljevs | Assignee: | Unassigned |
| Resolution: | Won't fix | Votes: | 0 |
| Labels: | database, dbpatches, schema, units | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
Currently, the length of "units" field in "items" table in the database is 255 characters. This seems to be much more than necessary. A length of 32 or 64 characters would be more appropriate. |
| Comments |
| Comment by Aleksandrs Saveljevs [ 2015 May 26 ] |
|
Decided not to fix it, because it does not provide any real benefit: a string of 10 characters would occupy the same space in both varchar(32) and varchar(255). Furthermore, someone may already be using longer units for one reason or another. |