while (true) { identify_and_fix_bottlenecks(); drink(); sleep(); notice_new_bottleneck(); }
– Use explain to how your queries are running. Indexes may not be being as you expect. – Denormalize a lot. Single handedly saved them. For example, they store all a user IDs friend IDs together, which prevented a lot of costly joins. – Avoid complex joins. – Avoid scanning large sets of data.
0 Comments
|
AuthorAshish Abrol is a Technical Evangelist at heart. As a Web Architecture Consultant he specializes in IT Management Consulting and Enterprise Architecture with a speciality in High Performance SOA and Open Source Frameworks. I sure did take a long time to enter actively into blogosphere. Honestly, as a passive player all this time, I have gained a lot from the adept content of some serious bloggers. That strongly encouraged me to contribute back to the community, and learn in the process as well.
-Ashish Archives
July 2020
Categories |