Database Upgrade
I just upgrade the MySQL database that runs all of my sites and changed a few options to try to get some more speed and a few new feature, well not new features as much as bugs fixed in a feature I was trying to use. MySQL has a way that you can insert data into the database and if the data is based on a unique key and the unique already exists it will update the data instead of sending out an error. I’m in the process of trying to create some summary tables for the IP database and this feature is going to come in so handy I can’t describe it. It was broken on the version of MySQL I was running, but the upgraded version seems to be working fine. While I was upgrading MySQL I found a reference to caching query in MySQL. I am already doing this in ColdFusion, but if MySQL can do it as well I’m expecting quite a bit more performance out of this little server
Hopefully things will work well and I can get back to the work at hand ![]()






