Answer the question
In order to leave comments, you need to log in
What is the proper name for indentation?
Good afternoon. We want to brand the site, and fill in the indents on the left and right with logos, etc. The question is, how is this distance on the left and right correctly called.
Of course, I understand that this question is a little strange, but I really did not find it anywhere-)
Answer the question
In order to leave comments, you need to log in
Even in layout, in CSS, this is the “margin” property (margin-left, margin-right).
There is also padding.
Let's assume that there is some container with contents. The margin from the outside of the container is the margin. Padding inside the container (from borders to content) - padding
This query does not need to be optimized, because, despite the frightening size, its structure is simple. The speed of its operation depends on the indexing of the fields by which the tables are linked.
All brackets after FROM can be removed as unnecessary.
DROP DATABASE yourdb
No database, no problem :-)
But seriously, you need to reduce the number of JOINs, for example, saving some or all of them in a temporary table, it depends on how often the main table is updated.
For example, if the time of adding-changing a record is not critical, then you can create a temporary table immediately after adding the change.
Indexes on fields from ON, I hope, have already been placed
1) Try Analize The database will tell you
2) Defragment the tables (OPTIMIZE TABLE `t`)
3) Check what happens through explain when you try your options.
4) Make sure that the correct data types are substituted in the request. For example `field` = '1' and `field` = 1 - the result is the same, but the second option is faster.
You can try to denormalize and bind the data with triggers if the number of reads significantly exceeds the number of writes.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question