Decaflon

Me: "... whether you care if it uses Javascript or not ..."

Them: "I don’t particularly care if it is in Java or not. I just want it to work."

Gah!!! If they had just called it something like "Awesomescript," I would never have this problem.

I've been working on Facebook applications and I would like to conduct an "informal poll" with the 9rules community. To cut to the chase, please respond with either:

• I don't use Facebook
• I use Facebook, but I don't like Facebook apps because they are:
  1. Stupid
  2. Not worth the time
  3. Clutter-riffic
  4. Some other reason
• I do use Facebook apps (and let me know if you've ever developed any)

Also, please do share any ideas you have about the things Facebook apps shouldn't do, like forcing you to an invite page or putting a bunch of spam on your profile. I'm thinking of writing an "app manifesto" for things that app developers should agree to and I could really use ideas. Thanks in advance!

I've hit a roadblock due to the fact that I don't know much about this problem so I'm looking to see if people with more experience can give me some advice:

What's better? I've got three sites, one gets 40k hit/day, another 15k, another 10k. They are not very well optimized but I'm working on that (adding caching, etc.). Say I could move all three sites to one very powerful server (2x Quad Core Xeon, SAS Drive, 2G RAM) or move each site to a separate "pretty-good" server (Dual Core Pentium D, SATA Drive, 1G RAM). All the other features are the same, OS setup, Fast CGI, APC/Cache::Cache, etc. These are Perl/PHP sites with MySQL backends.

Any advice?

I can't mention the parties involved here but my employer is having a hell of a time with their hosting company and since I'm the lone developer, I have to figure out the right solution.

We were moved to a new server last week because the old server we were on was occasionally crashing, more than once each week. The host said it had hard drive issues so they moved the sites. This server has 3 sites that all receive very high traffic.

Since we moved we started seeing issues with the sites running slow. There were lots of things that happened during this time so it's hard to tell exactly where the problem was. I'll try and lay out the different issues:

- one of our sites doubled in traffic. it is a PHP/MySQL site and has zero caching. It was developed externally and I told the developers to cache the pages. It should be done by next week.

- we moved to a new advertising service and to make the management of adds easy, I wrote some scripts with PHP to use a MySQL database and serve up the ads. At first this slowed the server down a lot so I cached all the scripts so that they wouldn't have to do any queries. These files currently look like this:

if(file_exists...)
include('xxx');
exit;
?>

2 of our sites use these scripts, they make up about 80% of the traffic.

- I added a feature to one of the sites that meant an extra database request on some of the highest-traffic pages for that site. We then had some issues with performance so as an extra measure I implemented Perl's MemoryCache module (this is a Perl/MySQL site). So I was caching some of the results of various functions in memory and these caches were set to last for an hour. I was also auto-purging every hour.

Last Monday our server had 1 gig of RAM. the host recommended we increase that... now we have 3 gigs. We were at 90% memory consumption when we had 1 gig. Today, with 3 gigs, we suddenly hit 99% consumption. The sites have been slow all day.

In the morning the host was saying that it was MySQL eating up all the memory. In the afternoon, however, they said we had too many PHP and CGI processes running. They recommended upgrading to a server with a more powerful CPU.

I can't do much on my end to verify any of this because we have a "managed" dedicated server, which means I can't do much on the command-line. It's very frustrating, and the host's support is not very good.

So, um, what do I do? Is this thing about the PHP/CGI processes really true? I know the server doesn't have a very good setup (no FastCGI). Would changing the ad system to use static HTML files improve things (since most pages have on average, 3 iframes, each running a separate PHP file)? Should I just assume that our host is problematic and look for hosting elsewhere (I'm leaning toward this right now)? At least if we were on a better server with root access, I could setup PHP/CGI better and get more performance.

I'm just looking for any advice here... this whole mess is keeping me from doing *real* work.

p.s. this is an Apache Linux server.

A contractor we are working with is using a MySQL temporary table to fetch some data from three different tables in our database. Our sites are already memory intensive and it seems to me that using a temporary table is too costly, but the contractor insists that it greatly improves execution time so it's a good idea. Who's right here? Has anyone used temporary tables before?

I've been learning Perl's Cache::Cache module today and I'm having a really tough time with Perl's syntactic niceties. I'm especially having trouble returning a bunch of variables to a single array and then setting that array into the cache and accessing the members of it. I've been able to cache other functions where I'm just dealing with one scalar but things get so confusing with arrays. Unfortunately I can't find any tutorials or documentation online so I'm hoping that someone on here knows Perl and might point me in the right direction. Otherwise I can post the code that isn't working and maybe you can tell me what I'm doing wrong.