Drupal Performance Tip – 'I’m too young to die' – know your DB engines
This title could be clearer and more informative.Try out Clickbait Shieldfor free (5 uses left this month).
Drupal 6 used MyISAM tables while Drupal 7 switched to InnoDB. A key performance pitfall is using SELECT COUNT() queries, which are fast on MyISAM (uses main index) but cause full table scans on InnoDB, leading to poor performance on large tables. Developers should audit modules — especially those migrated from Drupal 6 — for such queries, and consider the impact on modules like Views that rely on COUNT() for pagination.
Sort: