Faster SQL

After few months of working in (also I notice that the home page is kind of slow.
So I give it a thought and decided to go a head and update my SQL commands in the home page only to be faster.

Basically what I did was combining all home page SQL commands into one (actually two) instead of the way it was executing (was executing around 15 SQL commands).
This enables me to make the home page faster, much faster, from 4 seconds to less than 1 second.
Yes, that is fast.
It is true, it took from me around 6 hours of work and added too many lines of code. But the result was satisfying.
ANmars blog programming developing webdesign