Don Gould wrote:
I'm in!
Performance tuning with mySQL.
Err... dunno about a talk on performance tuning. Often one can usually
speed things up by using a few basic rules which I might be able to
cover but I am no expert on DB performance tuning.
That is a whole skill all on it's own.
Things to check and do might be:
- ensure that your table indices are set up correctly for the way you
are querying the table. Especially for big tables.
- put heavily used tables into RAM, like lookup tables etc.
- try to reduce the number of times you send queries to the database.
Usually it is better to use a more complex joins than hit the DB
multiple times. Stored procedures are always preferable but I don't
know exactly how good they are in MySQL.
Good luck :-)
Zane
