Making Dragonfly Faster ⇒ Frequently Asked Questions ⇒ CPG Dragonfly™ CMS
How can I reduce the load generated by MySQL?
This is easy when you are familiar with how queries work
For example the easiest way to program is like this
This results as X queries where X is the amount of forum posts you have made.
This is really stupid if you only need the last 10 posts because it can produce 5000 queries.
Think and merge (JOIN) the 2 queries and LIMIT it to 10 results.
INNER JOIN means: merge and output selection if the two tables match. So if the query in ON () fails, the record won't be shown and counted.
This way, only one query is used, and you see a boost in the page generation time
How do i get even faster page generation?
Check your home page, do you have 50 blocks?
Reduce the number and check the time, or maybe it's just one block causing the issue.
If you are retrieving data from another site via RSS/XML or other methods, your page generation will be only as fast as that site is available.
Also check any custom images what are the file sizes?
Can you optimize those more?
remember most people are still on dialup.