![]() ![]() ![]() In most cases, once our SELECT queries slow down, the entire application backed by our database noticeably slows down as well. The optimization of SELECT queries is the hottest topic of any database performance discussion, and, consequently, the most problematic one as well. ![]() However, while we will split the advice we give you into two aforementioned parts, some parts of the article will apply to both types of queries, so make sure to familiarize yourself with all information before proceeding to optimize queries on your infrastructure – take a backup of your data, and let’s go! Optimizing SELECT Operations Once you feel that the problem is within your database, first decide what kind of queries are you going to optimize – think of the CRUD ( Create Read Update Delete) principle and break it down, then choose the option to go with: the first method we are going to walk you through will help optimize queries that read data ( SELECT queries), and the second method will help with INSERT, UPDATE and DELETE query optimization. Once that’s out of the way and you still feel like the problem is within the database itself, read on and we will walk you through everything you need to know. Finally, another very important thing to keep in mind is the fact that your application can be slow due to a multitude of factors including DDoS and other kinds of attacks (DDoS attacks aim to overwhelm the infrastructure of an application effectively grinding it down to a halt), so before working on the performance of your database queries, make sure to take good care of security measures as well – directing traffic through a CDN provided by CloudFlare or other vendors should help.
0 Comments
Leave a Reply. |