![]() |
Software MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks! I still hear an awful lot of stories from owners whose databases are running two slow. In my experience, the three main places to look for problems are: 1. Faulty Database Design 2. Bad Queries 3. Server factors Faulty Database Design
Bad Queries It sounds too good to be true but you wont believe the number of developers out there who completely suck at writing queries. There are two types of bad queries: a) Unnecessary Queries: These are the queries that shouldn’t have been made in the first place. The only way to avoid this is asking, “Do I really need this data?” b) Inefficient Queries: These are the queries that do not use the underlying table structure or MySQL functions in the correct way. Here is a starting point to start looking at problem areas:
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||
| © Copyright 2006, pcbusiness.org |