LGF Database Rocks
Charles Johnson
Sun Apr 1, 2007 at 6:29 pm PDT • Views: 172
OK, I’m almost ready to declare the database redesign an unqualified success. Server loads are way down, and all the modules are operating well. I’ve been monitoring the MySQL activity with the mysqladmin tool, and all systems look good. (As I mentioned before, the real test comes tomorrow, with our weekday traffic surges.)
Note: two modules I mysteriously forgot to update have now been MySQL-ized—the “email an article” script and the LGF Headlines Javascript module. If you had trouble with either of these features, it should now be fixed.
The LGF search engine is the real flagship of this upgrade. One of the biggest problems, as LGF has grown, has been the difficulty of organizing and finding the vast amount of information at the site. This search engine is the tool I’ve been looking for; it’s so much faster and so much more powerful than the old search that it acts as a sort of virtual index.
All searches are now logged, as well, so I can keep an eye on how the search engine’s being used and optimize things that need optimizing. So if you’re someone like, oh, say, Glenn “Sock Puppet” Greenwald, and you’re thinking how great it’s going to be to use our own search engine to cherry-pick through LGF’s comments and launch more smear jobs and hypocritical attacks—well, let’s just say I’ll be watching.
Frank says: