Have you tried explain?
Do all of your ID fields have indexes?
Have you tried breaking it into multiple statements? Each statement creating
a temp table except the last?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Lorenzo De Vito [mailto:[EMA
At 06:25 PM 5/13/2002, you wrote:
>Hi,
>
> I have the following query and everytime i try to run it, it
> returns an
>error "Mysql server has gone away". Is it beacause the query is very slow?
>If so, how can i speed it up?
>
>Query ->
>SELECT a.idemail, a.fklastresp
>FROM wmkt_email a, w