On Wed, 15 Nov 2006 21:05:49 +1300 Zane Gilmore <[EMAIL PROTECTED]> wrote:
> 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 The best way to improve the performance of a database is to rewrite the application code to be more efficient. The rest is a few percent here or there. Developers are a DBA's worst enemy. Steve
