How can I make my MySQL run faster.
I've got a fairly small database (<30,000 products) but there
are 60 columns for each row (this is a must).
Each simple find query takes about 3 seconds, which is way
too long.
Query is something like:
SELECT *
FROM blah
WHERE product_model=123 AND product_name=abc LIMIT 1
I'm trying to figure out if putting more than 512 RAM or upgrading
from a celeron 1.8 to a P4 2~ will have a SIGNIFICANT difference
in speed.
I'm leaning towards getting more RAM and possibly upgrading
to another EV1 server and would like to hear your input.
Thanks,
Luc L.
