Tell me a cozy library with free wi-fi in Moscow

Question

Freelance

I think the library is the perfect place for focused and comfortable work or study. Haven't been to the library in years. I wonder if there are such libraries with free wi-fi, a comfortable workplace. Also interesting - how to get a subscription

Answer 1

I'm writing from the RGB . Issued a library card for 100 rubles, valid for 5 years. Wi-fi is excellent (2nd reading room on the third floor). The atmosphere is wonderful. They just made me hand over my backpack at the cloakroom. I had to put all the contents in a bag. In fact, everyone here walks with bags - so don't be fooled.

Answer 2

And here is a catalog of similar places placeplaceplace.ru/

Answer 3

Thanks for the link!

Answer 4

First, the length has nothing to do with "packing the server". It's not the size that matters, it's the skill. It is not the query that needs to be reduced, but the number of lines scanned by the query.
Secondly, it is necessary not to ask idle well-wishers, but to see for yourself whether the request is slowing down or not. If not, then don't sweat it ahead of time.
Thirdly, why not ask the same "expert" who told you this?
The only problem I see here is the multiple exists sub-selects, which can become a problem with a large sample . But if the sample is small, then there is no problem.
If you really want to figure it out, then first run two commands in the console

\W
EXPLAIN EXTENDED дальше твой запрос

and look at the table. If the numbers in the rows column are cheap, then don't worry. At the same time, you can see what the optimizer has turned your query into - perhaps he has already learned to translate this beauty into joins himself.

Answer 5

I saw the previous question, and it seems to me that the best solution would be to redesign the database structure so that there is no need to extract something from substrings, that is, for example

cities
+---------+-----------+
| city_id | city_name |
+---------+-----------+

stricts
+-----------+---------+-------------+
| strict_id | city_id | strict_name |
+-----------+---------+-------------+

posts
+---------+---------+-----------+
| post_id | city_id | strict_id |
+---------+---------+-----------+