Re: Query slowing down, need advice

Thanks for your input. Especially Tod for breaking it down at the hard ware level and making me realize what is possible. I have re-evaluated how this is going to work. Instead of trying this with one query, I am using 2. I forget somethimes that MySQL is better at running simple queries reall

Re: Query slowing down, need advice

t; <[EMAIL PROTECTED]> > To: "Brian Moon" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, August 16, 2002 10:51 AM > Subject: Re: Query slowing down, need advice > > | On Fri, 16 Aug 2002, Brian Moon wrote: > | > I ran into

Re: Query slowing down, need advice

have problems with. The query is not just slow, it does not return. Brian. - Original Message - From: "Thomas Spahni" <[EMAIL PROTECTED]> To: "Brian Moon" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 10:51 AM Subject: Re:

Re: Query slowing down, need advice

On Fri, 16 Aug 2002, Brian Moon wrote: > I ran into a problem when the queries started to call for 500,000+ rows. > The query would not return. Here is the query and explain: > > select SQL_NO_CACHE id from single_table where approved='Y' AND datestamp >= > '2001-08-16 00:00:00' AND ( ( author

Query slowing down, need advice

Hi, I am the lead developer of Phorum . We are starting to see some users with 1 Million messages in their forums, including me at dealmac.com. I am trying to optimize the tables and I am having good luck analyzing the keys and building better ones. However, I am having a pr