Very slow dependent subquery

[patrick canarelli]

hi
I am querying the following and it is very very long (2 hours with customer < 300K records and btree indices and parameters setup correctly I believe) :

INSERT INTO temptable (CODE_CLIENT, TEMPVAR1)
SELECT
CODE_CLIENT ,
(SELECT SUM(t1.AmountPaid) FROM purchase AS t1 , member AS t2 WHERE t0.CODE_CLIENT = t2.CODE_CLIENT AND t2.EMAIL = t1.EmailAdress )
FROM customer AS t0


The explain of SELECT is :
id 1
select_type PRIMARY
table t0
type index
possible_key NULL
key IDX_CODE_CLIENT
key_len 63
ref NULL
row 282716
extra Using index

id 2
select_type DEPENDENT SUBQUERY
table t2
type ref
possible_key IDX_CODE_CLIENT, IDX_CODE_CLIENT_DATEJOIN, IDX_CODE_CLIENT_EMAIL, IDX_EMAIL, IDX_EMAIL_CODE_CLIENT
key IDX_CODE_CLIENT
key_len 63
ref test.t0.CODE_CLIENT
row 1
extra Using where

id 2
select_type DEPENDENT SUBQUERY
table t1
type ref
possible_key IDX_EmailAdress, IDX_EmailAdress_Date, IDX_Date_EmailAdress
key IDX_EmailAdress
key_len 768
ref test.t2.EMAIL
row 23
extra Using where


Tables are MYISAM
Parameters are :
key_buffer_size=256M
tmp_table_size=256M
max_heap_table_size=256M

This query is abnormaly slow even if purchase has 15M records as everything is indexed.
Would someone have any idea about what's wrong ?
Thanks for your help.
Patrick