Drupal is a content management system. For those of you not familiar with it, it's sort of a Swiss Army Knife of the CMS world. It can do a shitload of things, and thanks to a pretty extensive community and a quite excellent plugin system (essentially you just take some PHP written by someone (to spec of course) and shove it in a specific directory and it works), anything it can't do, it can still do.
The problem with anything Swiss is that when it tries to do everything, the individual pieces suffer. It's like, with an actual Swiss Army Knife, you have like a pair of tiny scissors and a knife and a nail file and maybe even a tiny saw and probably a bunch of other sharp things that you're not sure what they do, but there's a fuckload of them so they must be used for something. So when you're out camping it's nice to have them because it's compact and convenient, but the reality of the situation is that if you had brought some real scissors and a real saw and a nice steak knife and your nail clippers with the fold out nail file you would be a lot better off because individually all of those things are 100% better than their corresponding component in the Swiss Army Knife. Sure they take up more space, but would you rather use a nice serrated steak knife made by a knife company that knows what they're doing when it comes to knives, or the Swiss Army who are kind of okay at making knives but mostly they're just awesome at cramming a bunch of random tools into one item.
Drupal is kind of like that. If you use Wordpress or fucking MovableType for a simple blog, it's better than Drupal. However if you want to make anything more than a simple blog with Wordpress you're kind of fucked. This is where Drupal comes in.
I just checked out the development site we have up (I'm not going to mention where I work or what site just in case), and the home page has quite a bit of information. It has to pull headlines from all over. This is what it has informed me: Executed 1779 queries in 2445.35 milliseconds.
Holy shitdamn fuck.
1779 queries?! Mind you there is caching not present for this since I'm logged in as the admin user, but holy Jesus on a stick what? Dear god. The way it's put together is so complex and convoluted that is has to pull from a million different tables and files and oh man it's awesome.
Still it has its moments. Like I said the modules/plug-in engine is really awesome, and it's really apt at themes and there's a ton of ways to customize it without ever editing a single flat file. You can add new types of content and list it how you want and sort and filter and everything you'd expect.
I have no ending for this, because I'm tired just thinking about Drupal. I really want to take a nap now. Holy crap. Good night!