Deprecated: Assigning the return value of new by reference is deprecated in /home/harttic/public_html/wordpress/wp-includes/cache.php on line 36

Deprecated: Assigning the return value of new by reference is deprecated in /home/harttic/public_html/wordpress/wp-includes/query.php on line 21

Deprecated: Assigning the return value of new by reference is deprecated in /home/harttic/public_html/wordpress/wp-includes/theme.php on line 507
Clueless Finn » Blog Archive » Improving the speed of the site for ultimate national team games - Part 1

Improving the speed of the site for ultimate national team games - Part 1

The National Teams of Ultimate site is slow. Period. I am painfully aware of this fact and constantly working on improving the site speed. Based on my rough analysis, there are 4 ways to improve the page download speeds:

  1. Speed up the pipe to the server / improve server speed / use content caching. This is no-go because of the costs and because the improvement for the download speeds would be minimal
  2. Decrease the time spent in various db SELECT queries needed to get the page content from the db. I have already attempted this earlier with limited success. There is lots of room for improvement in here though. Have to get back to the drawing board
  3. Decrease the amount of SELECT queries needed on each page. Not much room in here except for the all_tournaments.php and all_countries.php summary tables pages. Otherwise there is no excessive number of queries to the database on any page.
  4. Convert the whole site to a pile of static pages - I am working on a development server after all and the site is static between each content update (currently those have been happening every week or so)

Today I took initial steps in testing how the conversion to a static site would work. First test was a failure. I downloaded a neat tool called SiteSucker, which recursively traverses the site and fetches the pages to a local folder (yes, I could have used recursive wget instead…).
All that worked well resulting to 15,000+ pages (about 105MB) which is still ok. The problem is that I am using forms / pull down menus for site navigation - those do not work well if the dynamic pages are converted to static pages / URL without the URL parameters. So I have to either change the navigation logic on the pages or I have to find a dynamic-static conversion tool which preservers the URL parameters. Any hints?

Comments are closed.