John, Have you got a single multi-column index on countyid, price and old, or do you have individual indexes on each of these fields? The former would be much better.
Andy > -----Original Message----- > From: John Smith [mailto:[EMAIL PROTECTED] > Sent: 11 November 2004 14:15 > To: Victor Pendleton > Cc: [EMAIL PROTECTED] > Subject: Re: Queries taking 60 seconds+ > > On Thu, 2004-11-11 at 13:58, Victor Pendleton wrote: > > What does the explain plan look like? > > > > id select_type table type possible_keys key key_len ref > rows Extra > 1 SIMPLE properties ref old,price,countyid countyid 3 const 9233 Using > where; Using filesort > > The filesort I know is a problem but I thought I read sorting it using > myisamchk by the price key helps this. > > Also if I remove ORDER BY and the price >=1 AND old = 0 the query still > takes 46 seconds which is too long for a dynamic site that I am trying > to build. > > John > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
