I’ve always hated SQL. From the day I installed one of the first IBM VM/SP versions on our 4361 mainframe back in the early 1980s, until today, with still no end in sight. It ran like a dog back then, which is geek speak for s l o w l y, and still has a whole swag of issues to deal with which ignorant sysadmins and amateur database architects still get wrong.
So the other day I converted this blog from using super fast Perl DBI hash ties, in which I’ve simulated a relational database, to good ol’ SQL, MySQL in particular. The choice was not mine, but the complexity of some code I was working on, which needed a bit more order than ordinal arrays of pseudo database columns.
Anyway, so I converted the code over, and it runs like, you guessed it, a dog. It was initially taking 30 seconds to load the main page, and then the following day that stretched out to about 5 minutes. Once a dog, always a dog.
My hosting provider then found a server problem, which they haven’t fully fixed or conveyed to me yet, but the site is running a little faster now, which saves a bit of backout work. Suffice to say, it may not be MySQL, but I like to tar everything with the same brush, so MySQL it is.
SQL, the COBOL of databases.