Affiliate Program?

I forgot to add in the last entry, if we can actually generate some guaranteed revenue to cover the costs of the site, we can actually put in place a decent affiliate program. To that extent we would also plan on implementing something like this; DiaristA tells her friend, DiaristB about DearDiary.NET (or AtomIC Systems)….

DOH!

Well, great news… The server was running nice and fast for about, err, 10 hours or so. And then crashed when it tried to do the nightly update!! Its done that once before, where the whole scripts just consumed all the database connections and left none for the web… Thats what happened this morning too……

Thoughts on Performance

Surely it is amusing that I write in here, instead of getting my own diary up to date? 🙂 Hehehe 😉 I’ll get back to it, honest 🙂 I just wanted to note down some thoughts on performance of Websites – for those readers that are building, running, or even just considering running their own….

We think we found it….

The system slowdown was due, we think, to a database query not using an index to find the information it needed… After looking deeply into the MySQL manual we discovered we could have the database actually tell us which queries were running slowly. From that we can then tell the database (manually) to tell us…

System Slowdown

Some of you may have noticed (indeed, we’ve had at least one email saying someone had noticed :)) the system has been running slower in the evenings (US evening time). On one hand this is good news because it means the server is getting used a lot more, and by golly it is getting used…

It's not a conspiracy

We really are out to get you… uh, no hang on. 🙂 The observant among you may well have noticed that Steve (DeLancie), myself (NeutronIC) and this diary (deardiary1) have appeared on the top ten most read diaries. Furthermore, i’m in position 1 and Steve is in position 2. I’m just writing to say that…