Subject: Re: MySQL Optimization Assistance
From: Joshua Kugler (jk@as.uaf.edu)
Date: Mon Nov 10 2003 - 15:14:58 AKST
I'll answer on-list too, as it may help others.
Some general tips
1. Make sure you have indexes on all the columns in your WHERE clauses
2. Try not to use TEXT/BLOB fields or VARCHAR fields unless you really, really
need to
3. If you need to be able to search on ANY field in the table, and you need
speed, index them all: it'll take lots of disk space, but the time payoff
will be worth it
I can't really comment any further without seeing the layout of your database.
It is possible it needs some normalization, or other optimization.
Let me know if I can help further.
j----- k-----
On Monday 10 November 2003 10:56 am, KSchneider wrote:
> Hi guys --
>
> I'm looking for some optimization advice from someone who knows mysql
> really well (read: better than I). I've got medium-sized tables that are
> running slower than they should.
-- Joshua Kugler Assistant Systems Administrator UAF Department of Mathematical Sciences UAF LUG President --------- To unsubscribe, send email to <aklug-request@aklug.org> with 'unsubscribe' in the message body.
This archive was generated by hypermail 2a23 : Mon Nov 10 2003 - 15:14:58 AKST