Re: UTL_SMTP Multiple emails on same connection (not multiple recipients)
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: <michaeljmoore@xxxxxxxxx>
- Date: Sat, 4 Sep 2010 10:25:05 +0200
Michael Moore pisze:
> Apparently, what I am asking is not a common thing to do. This tells me
> either it's not possible or there is little to be gained by doing it. I
> don't really have a performance problem I am trying to overcome, it's just
> that I'm a bit of a purist, and I don't like code that does unnecessary
> steps including opening and closing connections if not needed. :-)
On the other hand a question is, does "opening a connection" really
means opening it every time.
> Thanks for your help.
> Mike
>
> On Wed, Sep 1, 2010 at 8:47 AM, David Robillard
> <david.robillard@xxxxxxxxx>wrote:
>
>> Hello Mike,
>>
>> On Wed, Sep 1, 2010 at 11:00 AM, Michael Moore <michaeljmoore@xxxxxxxxx>
>> wrote:
>>> David,
>>> thanks for your response.
>>> I've seen lots of ways to send the same email to multiple people, but as
>>> you've surmised from my pseudo code, what I want is different emails
>> going
>>> to different people. I am assuming that there is overhead on OPENING and
>>> CLOSING the CONNECTION. So, I am trying to avoid doing the open/close for
>>> each unique email. Maybe my assumption is wrong?
>> I honestly don't know as I've never used this particular package. But
>> yes, I would tend to think that would cause a little overhead. You
>> might want to check with Oracle support about it?
>>
>> You can also check your database server's resources. If your machine
>> has plenty of CPU cycles and memory to spare and Oracle support says
>> the overhead is low, then maybe that's what you'll have to do. Even if
>> it might not be super-efficient.
>>
>> HTH,
>>
>> David
>>
>
--
Pole nakazi
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos : DBA at DIiUSI
addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod numerem:
0000021828,
dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku,
VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego,
o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych,
NIP: 586-000-78-20, REGON: 190024711
--
//www.freelists.org/webpage/oracle-l
Other related posts:
