Thanks to technomunk and remiss, I’ve figured out one of the major problems that has been pwning the speed of the site.

To try to get more funds to get another server to handle the increase in traffic (which has now been driven away a bit by the slow page-loads), I started experimenting with other ad services. I tried TextLinkAds, AdBrite and ContextWeb. The layering of these ad networks was what appeared to be destroying page-loads.

It worked like this:

  1. TextLinkAds would check their server for any new ads through a fopen() type request (so they loaded another page).
  2. Since no TextLinkAds have been sold, the ContextWeb code would then be called.
  3. After a few page-loads ContextWeb no longer seemed to be able to find ads for us (maybe because their spider gave up on our slow pages?) and it would default to call the AdBrite code
  4. AdBrite would make sure that it could compete with the eCPM of Google AdSense (eCPM means estimated cost per thousand page loads… ‘m’ stands for mili in latin). Since AdBrite could not get high enough bids, it would then default to the AdSense.

So all of this was happening just to end up calling AdSense anyway. Lame! Guess we’re stuck with AdSense for the moment.

Remaining problems:
The first page-load is still really slow. UPDATE: Fixed!
The SOAP is still slower than I would like, but that’s another issue (that I’m working on… it’s straightforward, but will take some time to write/test). UPDATE: Also fixed now!


2 Responses to Speed!

  1. lyricwiki says:

    UPDATE: First page-loads were still coming in way too slow. After a bit of analysis, I found out that max_connections wasn’t getting set correctly. That’s fixed now, so first page-loads are cranking pretty fast. After some more debugging with SHOW PROCESSLIST, I found that a relatively useless query was running quite frequently and I have since removed that query. The number of concurrent queries then dropped from around 30 to somewhere between 5 and 10.

    Everything is much faster (and traffic has been picking back up as a result)! šŸ˜€

  2. stonecrest says:

    Great to hear! Hopefully you also can get the SOAP sped up as well šŸ™‚

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: