> Thanx Dave!
You're welcome!
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or on
Thanx Dave!
On Sun, Aug 8, 2010 at 9:16 PM, Dave Watts wrote:
> In SQL Server, anything beginning with "sp_" are stored procedures
> built into SQL Server. So, the driver invokes those SPs to create and
> invoke a new temporary SP. Temporary objects (including these SPs) are
> tied to the conne
> So does the driver just call that API on the DB and the procs are
> created inside the DB? What causes the procs to go away later? (I
> assume they're GC'd at some point otherwise you'd end up with millions
> of them in the DB :)
In SQL Server, anything beginning with "sp_" are stored procedure
On Sun, Aug 8, 2010 at 9:10 PM, David Mineer Jr wrote:
> I used codesion for years, then switched to unfuddle. Little cheaper and
> lots more features (at that time). Both are good but I sure love unfuddle.
I'll second the recommendation for Unfuddle for ease of use and great features.
Codesi
On Sun, Aug 8, 2010 at 9:06 PM, Dave Watts wrote:
> Yes, the SQL Server JDBC drivers from both DataDirect and MS do this.
> You can prove this for yourself by looking at traffic with SQL
> Profiler in SQL Server. You'll see an initial call to sp_prepareexec
> followed by subsequent calls to sp_ex
I love this freakin' mailing list. I get smart just by asking questions.
;)
G!
On Mon, Aug 9, 2010 at 12:06 AM, Dave Watts wrote:
>
> > > Most people don't realize that when you send a parameterized query
> > > using cfquery to SQL Server, what happens behind the scenes is that
> > > ColdFusio
I used codesion for years, then switched to unfuddle. Little cheaper and
lots more features (at that time). Both are good but I sure love unfuddle.
On Thu, Aug 5, 2010 at 10:20 AM, Dominic Watson <
watson.domi...@googlemail.com> wrote:
>
> Key features:
>
> * Security (proven enough to convinc
> > Most people don't realize that when you send a parameterized query
> > using cfquery to SQL Server, what happens behind the scenes is that
> > ColdFusion creates a temporary stored procedure on the server, then
> > executes that temporary stored procedure.
>
> Er, can you provide proof of that
On Sun, Aug 8, 2010 at 7:47 PM, Mike Chabot wrote:
> Most people don't realize that when you send a parameterized query
> using cfquery to SQL Server, what happens behind the scenes is that
> ColdFusion creates a temporary stored procedure on the server, then
> executes that temporary stored proc
> Does CF create that temporary stored procedure every time a single CFQuery
> is called? It seems like a bit of extra overhead.
No, these procedures are cached by the connection, so if someone else
has run the same query earlier the procedure will be pulled from
cache.
Dave Watts, CTO, Fig Lea
>>ColdFusion creates a temporary stored procedure on the server, then
executes that temporary stored procedure.
Does CF create that temporary stored procedure every time a single CFQuery
is called? It seems like a bit of extra overhead.
Curious,
G!
On Sun, Aug 8, 2010 at 10:47 PM, Mike Chabot
I wouldn't say that ORM systems have an "obvious advantage" in every
situation. There are plenty of good reasons to use stored procedures
that have nothing to do with efficiency. ORM systems and stored
procedures are not mutually exclusive. Many ORM systems allow you to
use stored procedures.
If
As an ISP, it isn't self-blacklisting that is the issue; if we get crap
from other servers, depending on the situation, we may blacklist
immediately. Once those limits are hit, you won't be getting mail here,
legitimate or otherwise. AOL, Yahoo, MSN, etc. all have similar
technologies deploy
The other moral of the story is to run your own mail server. Odds are you
won't be blacklisting yourself ;-)
Wil Genovese
Sr. Web Application Developer/
Systems Administrator
Wil Genovese Consulting
wilg...@trunkful.com
www.trunkful.com
On Aug 8, 2010, at 3:55 PM, Reed Powell wrote:
> So th
Here is what I've learned over the past week on this topic (talk about a timely
posting). I have a simple app that I use to send email blasts to my neighbors
about neighborhood events, etc. There is a database with the emails (about 150
records), and I just loop over it and do a CFMAIL to sen
We wrote an email marketing system that we used for about 8 years. Our
experience was that CFMAIL, since CF 7 at least, is plenty fast enough to send
out very large numbers of emails. The ColdFusion programming was the easy side
of things.
The challenges were on the systems side. Email relay
16 matches
Mail list logo