October
After completing a large chunk of code in August and September, in October I "took it easy". Not that I took any time off from the project. There were alot of little tweaks and bits and pieces I wanted to get completed before getting stuck into some of the sexy stuff. So what did I achieve...
Help from others
I put my heart and soul into this project, and there are three things which keep me motivated. (1) I love it when I see it comming together, (2) when I see people logging in and trying it, but last and by no means least (3) when I feel some support from others.
In October, Sarah Kavanagh (@slkav) created the login-splash page graphics.
Also, Daniel Crenna (@dimebrain) sent me a copy of his book "Twitter Developement". Daniel and co are the developers behind TweetSharp the Twitter API library twipler is using.
Adjust SQL Server Memory usage to 200Mb
The first major problem was application speed. The VPS Im using only has 512Mb, and Id read that SQL Server eats memory until you tell it to stop. I found an article about how to set the maximum memory usage which I set to 200Mb and restarted the agent. For the result, see below.
USE master EXEC sp_configure 'show advanced options', 1 RECONFIGURE WITH OVERRIDE EXEC sp_configure 'max server memory (MB)', 200 RECONFIGURE WITH OVERRIDE
