Re: Speed up slow SQL statement.

2008-10-24 Thread Moon's Father
_to_products table > >> to browse_nodes table > >> > >> anyone? > >> Martin > >> __ > >> Disclaimer and confidentiality note > >> Everything in this e-mail and any attachments relates to the offic

Re: Speed up slow SQL statement.

2008-09-29 Thread Rob Wultsch
__ >> Disclaimer and confidentiality note >> Everything in this e-mail and any attachments relates to the official >> business of Sender. This transmission is of a confidential nature and Sender >> does not endorse distribution to any party other than intended recipient. >&g

Re: Speed up slow SQL statement.

2008-09-29 Thread Eric Stewart
nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Speed up slow SQL statement. Date: Fri, 26 Sep 2008 10:42:07 -040

RE: Speed up slow SQL statement.

2008-09-26 Thread Martin Gainty
content contained within this transmission. > From: [EMAIL PROTECTED] > To: mysql@lists.mysql.com > Subject: Speed up slow SQL statement. > Date: Fri, 26 Sep 2008 10:42:07 -0400 > > Good morning everyone, > > I've got a sql statement that is running quite slow. I&#x

Speed up slow SQL statement.

2008-09-26 Thread Eric Stewart
Good morning everyone, I've got a sql statement that is running quite slow. I've indexed everything I can that could possibly be applicable but I can't seem to speed it up. I've put up the table structures, row counts, the sql statement and the explain dump of the sql statement all in pas