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
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
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
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
4 matches
Mail list logo