Public search slowed down the main database
Problem. Public property search used the main MySQL database, so the search and the internal CRM were slow.
What I did. I moved the search to a separate MongoDB database and closed the main database to public traffic.
Result. The main database has much less load. The internal CRM is not slow anymore, and public search works fast.