Sergey Spiridonov wrote:
problem is in query: SELECT messageblk FROM dbmail_messageblks LEFT JOIN
dbmail_messages USING (physmessage_id) WHERE
dbmail_messages.message_idnr = '551047' ORDER BY messageblk_idnr
which takes up to 6 seconds!!!
Slightly rewritten query
SELECT messageblk FROM dbmail_messageblks, dbmail_messages WHERE
dbmail_messageblks.physmessage_id = dbmail_messages.physmessage_id AND
dbmail_messages.message_idnr = '551047' ORDER BY messageblk_idnr;
is executed quickly. But I'm not sure if it will do exactly the same.
--
Best regards, Sergey Spiridonov
