In web development, there is often a story that you want your site to be lighter.
90% of the weight on websites that do not involve systems such as HTML and CSS is due to images.
It is a good idea to use webp and image compression tools while viewing the supported browsers.
However, this is not the case if the system is involved.
In this case, 90% is how to write the SQL of the database and the table structure.
A database is software that stores, stores, and retrieves data.
In short, the main thing of a web system is to store or retrieve it in this database.
Due to the weight of the database, the first thing you will notice is how to paste the index.
what is index?
I think you should think that it is close to adding a table of contents of the data.
However, you should be careful not to just paste the index into the dark.
Other details include changing the search order, changing the retrieved information, caching it, changing the configuration of the database, tuning it,
There will be various methods such as having multiple DB servers.
However, we have made some weight improvements, but the best solution is to reduce normalization.
What is regularity?
The point is to group the data information together.
Speaking of fruits, it is not a good structure to put citrus in the "category" of tangerine information.
In this case, if you make other lemons and put them in with citrus, it will be troublesome to change the information later.
In addition, it is better to create "category" information, put citrus in it, and link "fruit information" and "category information"
This will help you make changes later.
So why is it good to reduce normalization, which is a good technique?
Or, to put it a little more professionally, join or subquery.
Of course, the most ideal is to create a fast data structure even with normalization.
However, if there is too much data to be concatenated (but it is not good...)Stopping the normalization above is also an option.
You can also see other systems that display aggregations.
The system will also be slowed down if you are aggregating every time you view it.
This is in the background at the time of registration, or in real time,
It is also one of the hands to process them collectively in the middle of the night.
90% of the weight on websites that do not involve systems such as HTML and CSS is due to images.
It is a good idea to use webp and image compression tools while viewing the supported browsers.
However, this is not the case if the system is involved.
In this case, 90% is how to write the SQL of the database and the table structure.
A database is software that stores, stores, and retrieves data.
In short, the main thing of a web system is to store or retrieve it in this database.
Due to the weight of the database, the first thing you will notice is how to paste the index.
what is index?
I think you should think that it is close to adding a table of contents of the data.
However, you should be careful not to just paste the index into the dark.
Other details include changing the search order, changing the retrieved information, caching it, changing the configuration of the database, tuning it,
There will be various methods such as having multiple DB servers.
However, we have made some weight improvements, but the best solution is to reduce normalization.
What is regularity?
The point is to group the data information together.
Speaking of fruits, it is not a good structure to put citrus in the "category" of tangerine information.
In this case, if you make other lemons and put them in with citrus, it will be troublesome to change the information later.
In addition, it is better to create "category" information, put citrus in it, and link "fruit information" and "category information"
This will help you make changes later.
So why is it good to reduce normalization, which is a good technique?
Or, to put it a little more professionally, join or subquery.
Of course, the most ideal is to create a fast data structure even with normalization.
However, if there is too much data to be concatenated (but it is not good...)Stopping the normalization above is also an option.
You can also see other systems that display aggregations.
The system will also be slowed down if you are aggregating every time you view it.
This is in the background at the time of registration, or in real time,
It is also one of the hands to process them collectively in the middle of the night.
