Videoblogging theoretics, being the media, and the completely improvised future of a world currently without rhyme, reason or good beetroot fertiliser.
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.
Did you find this post interesting or useful? Or do you have some other comments/feedback on it? Please add a comment.
Main feed