Speed Up : Mike Little’s Journalized

Mike Little’s not-quite-so-daily thoughts, babblings, and random synapse firings!

A collection of random thoughts and links. Nothing too exciting. ;-) -- Mike Little

Wednesday, 24 September 2003

Speed Up

by mike @ 01:07. Filed under

Geek Stuff

With any luck, I have just managed to speed up the time it takes to generate my blog page. It should now be almost three times faster than before. I managed to narrow it down to the ‘posts_nav_link()’ function which gave the ‘older posts’/'newer posts’ links at the top and bottom of the page. These were taking as long to execute as the main blog loop (in fact they run almost the same database query). So for now they have been removed, which means you must use the archives, calendar, or categories links to navigate to the older posts.

[link]

The URI to TrackBack this entry is: http://zed1.com/journalized/archives/2003/09/24/speed-up/trackback/

5 Responses to “Speed Up”

alex Says:
September 24th, 2003 at 01:38
I’m using the ‘posts paged’ option with the previous_posts_link() and next_posts_link() and I don’t notice any performance hit.
kim Says:
September 24th, 2003 at 18:58
It’s much faster…don’t have time to
make a brew anymore
Steve Says:
September 24th, 2003 at 22:23
loaded in 1.936 seconds!!!
wow have you been feeding it weetabix?
Matt Says:
October 2nd, 2003 at 14:53
The difference is very noticable.
Mark Says:
October 10th, 2003 at 10:30
Kinda related to your stuff…

I found my SiteMaker pages were taking up to 12 seconds to generate. I eventually got this down to around 2 seconds by adding a bunch of indexes to the related tables. Mind you, my SQL bits were doing 4-5 table joins

I’ve not had time to look into speeding up WordPress pages by adding indexes. Its fast enough for me at the moment.

Please note: Comment moderation is currently enabled so there will be a delay between when you post your comment and when it shows up. Patience is a virtue; there’s no need to re-submit your comment.