Query optimization is the fastest way to speed up most apps. Enable slow-query logging, index the columns you filter and join on, rewrite N+1 patterns into batched loads. On MySQL, EXPLAIN reveals which indexes actually get used.
Query optimization is the fastest way to speed up most apps. Enable slow-query logging, index the columns you filter and join on, rewrite N+1 patterns into batched loads. On MySQL, EXPLAIN reveals which indexes actually get used.