Dev ported DB coded in SAP's ABAP to a ZX Spectrum emulator
When I built ZVDB, I deliberately applied every Z80 optimization I knew. Why? Because these 'old' techniques are timeless - they just happen to make modern code blazingly fast.
MySQL supports five exact integer types: TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT, which can be signed or unsigned, with the UNSIGNED option available for all types.