>Try using compressed indexes for your relations between tables. My Primary key is at most 4 characters long and is a character equivalent of a Base 249 integer.
>
While characters take up less space than numbers for the same number of variations, speed is much faster on searches with numbers. Would stick to numeric values for primary keys.