Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Sending Custom Mass Mail - Fastest Way Possible

by soonix (Canon)
on May 30, 2015 at 10:32 UTC ( [id://1128385]=note: print w/replies, xml ) Need Help??


in reply to Sending Custom Mass Mail - Fastest Way Possible

Seconding chacham's remark, I think prepending the table names with "$connect{database}." in the SELECT and UPDATE statements is superfluous, because you are connected with only that database.
Plus removing these parts would increase readability of the SQL strings.

Replies are listed 'Best First'.
Re^2: Sending Custom Mass Mail - Fastest Way Possible
by chacham (Prior) on Jun 02, 2015 at 14:08 UTC

    because you are connected with only that database.

    Good point. I completely missed that. FWIW, you can connect to another database in SQL Server by using a qualified object name, which includes the database name.

    Conversely, this cannot be done in Oracle, as it would require a database link, which instead follows the object name.

[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://1128385]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2024-04-26 04:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found