The performance of Mysql is frustrating to say the least. It seems like taking a step back after using the likes of Oracle and SQL Server.
If so many big organisations are now using Mysql there must be a way to get acceptable performance without having to continually jump through hoops. It appears that as soon as you start to get tables of any significant size then everything grinds to a halt.
My databases are only a a few million records, the largest is just short of 100 million. Updates are a complete nightmare and if you want to add an index or a new column then forget taking a coffee break, you might aswell go on holiday.
No comments:
Post a Comment