MySQL is one of the most popular database management system preferred by web developers around the world. The ease with which queries can be written and the seamless integration with various web scripting languages is the primary reason for this popularity. Most of the web programmers would have a hands on experience with MySQL. Complex database operations can be written quite efficiently with this open source database management system. This is true for low traffic web applications. But what happens when the traffic goes up? Will your applications perform well at high demands?
Surprisingly the answer is 'no'. You might get your applications working well when you test it at home but when you deploy it and is subjected to heavy traffic then things might go bad. There are chances of getting quite a lot of bugs or poor performing applications if your don't give close attention to your queries. MySQL is build for high performance and you can yield this power by writing proper queries and maintaining the database well. There are several thing to keep in mind while creating your tables which is set to deal with large amounts of data.
I came across a few posts from 'Linux For You' website which gives a few tips for writing better queries with MySQL which I would like to share with you folks. Here are the links.
Better Queries with MySQL, Part 1
Better Queries with MySQL, Part 2
Better Queries with MySQL, Part 3
These tips can reduce the overall load on your database server which in-turn accelerates your application performance. It doesn't matter if your application has low demands but if you intend to build a website that has to handle heavy loads then you should definitely keep in mind these tips.
Surprisingly the answer is 'no'. You might get your applications working well when you test it at home but when you deploy it and is subjected to heavy traffic then things might go bad. There are chances of getting quite a lot of bugs or poor performing applications if your don't give close attention to your queries. MySQL is build for high performance and you can yield this power by writing proper queries and maintaining the database well. There are several thing to keep in mind while creating your tables which is set to deal with large amounts of data.
I came across a few posts from 'Linux For You' website which gives a few tips for writing better queries with MySQL which I would like to share with you folks. Here are the links.
Better Queries with MySQL, Part 1
Better Queries with MySQL, Part 2
Better Queries with MySQL, Part 3
These tips can reduce the overall load on your database server which in-turn accelerates your application performance. It doesn't matter if your application has low demands but if you intend to build a website that has to handle heavy loads then you should definitely keep in mind these tips.
No comments:
Post a Comment