OK thanks Tom,
The application I am using for the site is www.zen-cart.com so I'm not sure
I can do anything about changing
the table indexes because it is a pre written php-MySQL open source freeware
script. I'm getting the query times
directly from the application and not MySQL.
However I
Message-
From: BD
Sent: Friday, January 07, 2005 11:58 AM
To: Tom Crimmins
Cc: mysql@lists.mysql.com
Subject: RE: Slow queries, need advice on how to improve; key_buffer -
zen-cart?
OK thanks Tom,
The application I am using for the site is www.zen-cart.com so I'm not sure
I can do anything about
[snip]
# Time: 050107 17:40:41
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 13 Lock_time: 0 Rows_sent: 148 Rows_examined: 1567270
use zencarttest;
select distinct m.manufacturers_id, m.manufacturers_name from
zen_manufacturers m
left