date-based email does not work with slow query

[jhagstrand]

Hello,

I created a date-based mailing and I set the appropriate dyn_target_tbl.target_sql to the following where clause:

date(created) >= date_sub(current_date, interval 7 day) and customer_id not in (select customer_id from mailtrack_tbl where mailing_id in (37,59,62,63))

As a stand-alone query this runs for about 30 seconds and returns usually around 1000 rows.

Within the date-based mailing, it does not work at all. No emails are generated. Do you know why? Is there a time-constrant?

John