Saving Bytes: Efficient Data Storage (MySQL) - Part 1
Hey there! Welcome to Making the Web - my personal blog about website development. Feel free to subscribe to my RSS feed to keep up with the latest. Alternatively, subscribe by email. Hope you enjoy this article!
When storing data in databases, it is important to ensure the data is stored using a minimal amount of space, while retaining its value and processing efficiency.
There are many common practices amongst MySQL developers who write applications which store data in a human-interpretable way; they often don't think about the computer's interpretation of the data, and often fail to realise that it can be more efficient and space-saving to store data in a certain form.
It is especially important to consider data storage techniques in high-demand applications, and where speed and storage-efficiency are key values. Web services require these key values: it is important that they can cope with extra demand, and can satisfy their user's desire for immediacy.

(Screenshot from phpMyAdmin)
In the first part of Saving Bytes: Efficient Data Storage, we will look at the storage of strings. __('Read the rest of this entry »')













