Re: Optimising SQL Statement

2013-04-28 Thread Jochem van Dieten
On Fri, Apr 26, 2013 at 12:56 PM, Richard White wrote: I am sure there must be a way to restructure this query to bring the time down I am afraid we can't really help because most of the information we need for that is missing. Schema, cardinalities etc. SELECT * FROM ( SELECT

Re: Optimising SQL Statement

2013-04-26 Thread Richard White
Hi, I am sure there must be a way to restructure this query to bring the time down but i cannot see it. Any pointers at all would be greatly appreciated. Hi, We have a problem with one of our MySQL statements and wondering if you guys can help point us in the right direction. Basically

Re: Optimising SQL Statement

2013-04-26 Thread Bobby
You could start by replacing SELECT * with SELECT column1, column2, column3, etc. On 4/26/13 6:56 AM, Richard White rich...@re-base.net wrote: Hi, I am sure there must be a way to restructure this query to bring the time down but i cannot see it. Any pointers at all would be greatly

Optimising SQL Statement

2013-04-05 Thread Richard White
Hi, We have a problem with one of our MySQL statements and wondering if you guys can help point us in the right direction. Basically the following statement is taking 5 seconds to run. We have diagnosed it is down to the join of two select statement. When the select statements are run