HOW TO ACCELERATE THE FUNCTION APEX_MAIL.SEND ?
602857Nov 26 2008 — edited Feb 27 2009HELLO EVERYBODY!
I DID AN APPLICATION WHICH HAS A TRIGGER ON INSERT IN A TABLE.
THIS TRIGGER SENDS AN EMAIL AND IT TAKES A LONG TIME FOR ARRAVING, IT IS ABOUT 6 MINUTES.
IT IS VERY SLOW, BECAUSE I HAVE TRIED WITH ANOTHER WAY USING THE UTL_SMTP.CONNECTION AND ITS PERFORMANCE GOOD.
I USED THE APEX FUNCTION LIKE THIS
APEX_MAIL.SEND(
p_to =>'ERIK@DOM.COM',
p_from =>'ERIK@DOM.COM',
p_body =>' MESSAGE:'||:NEW.NOMBRE,
p_body_html =>'<br> CLIENTE: '||V_NOMBRE_CLIENTE||', MAIL: '||V_EMAIL_CLIENTE||' <br>'
||V_MENSAJE
||' <br><br> DESCRIPCION: '||:NEW.COMENTARIOS||' <br>',
p_subj =>'REQ ',
p_cc =>'ERIK@DOM.COM'
);
WHAT DO I MUST DO FOR SOLVING THIS PROBLEM?
IS IT POSIBLE MAKE TUNNING TO THE APEX_MAIL.SEND?
ANY HELP WILL BE VERY APPRECIATED
THANK U IN ADVANCE.
BEST REGARDS