I've been having some problems with the web site lately. It's been randomly running out of system resources. This is probably because I've been relying on good-old Access databases to run several things around here (including the forums, blog, system log, etc.) and the site is starting to outgrow Access.
So... I'm slowly moving the databases over to SQL Server. I've already finished moving the system log and it worked just fine. The problem is AUTONUMBERS. It doesn't matter what the system log IDs are. Traffic gets logged, downloaded daily to my local Access DB for processing, and then deleted. However the IDs in the blog, forums, etc. DO matter... so I'll need to deal with that problem.
I'm also going to be upgrading from IIS6 to IIS7 (Internet Information Services) which is the server software that runs the web site. So if over the next couple of days you experience any outages with the site, that's why. Sorry for the inconvenience, but it's something I've just got to do. Fortunately our traffic is growing every day, and the web site has been running along OK like an old car for about a decade now. I keep adding duct tape and wire where needed, but the underlying foundation is getting too old to handle the increased traffic.
This is one of the reasons I'm late getting Access 8 and 9 out... still working on server problems!
14 years ago
