database query optimization
I'm a man of my word, as you can see. So, here I am now, ready to share with you 2 more efficient and conveniently easy to implement techniques to optimize your Drupal database. If, in part 1 of this blog post on database query optimization in Drupal I've highlighted: the “module way” (or “ways”, since it's 2 modules that I've drawn your attention to) of addressing the issue of low database queries, and the Solr-based index solution for weighing down your Drupal database (high traffic does come with its own drawbacks)...
And Drupal already has a nasty reputation for running a boat-load of database queries. Is your website highly trafficked and dealing with huge amounts of data to be retrieved and displayed in real-time? This will put an extra strain on your MySQL database. So, how do you optimize your Drupal database? Needless to add that this is the most straightforward way to give your website a rendering performance boost: The lighter and clutter-free your database tables are, the better your SQL query times will be. And, the faster your web pages will load..