There's a serious problem on this site, and it's starting to get really, really annoying. One of the reasons I built my own CMS was so that I could always find my content with just a few keystrokes. While this is typically true if I directly access the database, we are not able to find information with the same level of granularity on this and other 10Centuries websites. I have over 100,000 items stored in the database ranging from collections of "moments" no more than a few words long all the way up to some of the 3,000-word essays that are posted on here. This means that the existing search algorithms may work fine for the sites with less content, but it fails miserably when confronted with over a million words spread across a myriad of content types.
June 26, 2013 9:00 PM
April 27, 2011 6:00 PM
Earlier today I received a desperate email from a friend who has recently inherited the job of "database guy" at work. Unfortunately for him, he has little interest in being in charge of the database and even less chance of having the duty assigned to someone else. Unfortunately for me, this means that I'll be his go-to guy whenever he runs into a problem that needs a little more knowledge than he can find in the first 30 seconds on Google.
October 22, 2010 12:00 AM
Capacity Planning: It's a dilemma that has roots dating back before language, but something that many people struggle with on a daily basis. So how do we plan for it? Regardless of how many models and calculations a person runs, application performance eventually drops to nil when servers are over-run with more requests than the system can handle. This can happen for any number of reasons, but one common pattern that I see is that people don't really pay much attention to the day-to-day loads on their systems to plan for capacity increases. This is certainly a discussion at the planning and development stage yet, when everything is rolled out, some people wipe their hands of the matter and move on to adding functionality to the existing platform. Systems are then left unchecked until users start complaining about downtime or servers begin showing signs of trouble.
July 6, 2010 12:00 PM
May 24, 2009 4:00 PM
The internet is an interesting place. A few weeks ago I had posted an article showing people how to make Crystal Reports play nice with SQL Server Compact Edition. Since then, I've had a few people contact me with questions about how to use SQL Server CE as well as how to make Crystal Reports access other data sources. One question seemed to come up more often than any other, though: How do I get VB to access a MySQL Database hosted somewhere on the internet without granting a user direct access to that database?