Stored Procedure or ORM

2010-08-07 Thread Matthew Allen
This is rather annoying, the software development manager of the company I work for decreed yesterday that all (I mean ALL) web application we write in house from yesterday on, must now all be stored proc. No more inline-SQL and no more ORM because of one badly written ORM by a member of the

Re: Stored Procedure or ORM

2010-08-07 Thread Dorioo
No, inefficiency is not a solid argument. All 3 have their uses. My experience has been that DBA = dislike ORM because they lose some control. And since he's in charge - Gabriel On Sat, Aug 7, 2010 at 10:51 AM, Matthew Allen a.matthe...@yahoo.com wrote: This is rather annoying, the

Re: Stored Procedure or ORM

2010-08-07 Thread James Holmes
ORM makes your App DB-independent. Stored procs make your DB app-independent. If you have multiple apps platforms all needing to use the same data logic in a common DB that won't change, it makes sense to use stored procedures. If you have an app that you need to deploy out in the wild against

Re: Stored Procedure or ORM

2010-08-07 Thread Sean Corfield
On Sat, Aug 7, 2010 at 7:51 AM, Matthew Allen a.matthe...@yahoo.com wrote: He has one valid reason in that we have one or two (not the majority of) applications having the need to access data from different platforms (.NET, PHP and CF). You could create a simple REST API from CFML to expose

Re: Stored Procedure or ORM

2010-08-07 Thread Matthew Allen
Thanks for all the replies, I'll have to consider my options now. He seems to have taken this stubborn stance, at least I know what to get back at him with. Thanks, Matt ~| Order the Adobe Coldfusion Anthology now!

RE: CFML broadcasting app

2010-08-07 Thread Al Musella, DPM
There will be a problem if this goes to aol, yahoo, gmail, att, etc.. if you send too many emails in a short period of time, they blacklist you and the emails just disappear. I send a newsletter out to about 12,000 people and a few years ago experimented on how many I could send at one time..

Re: CFML broadcasting app

2010-08-07 Thread Sean Corfield
On Fri, Aug 6, 2010 at 3:47 PM, cfcom cf...@aceligent.com wrote: Several hundred thousand, possible 2MM You really need to look at one of the commercial mass mailing services. If you try to send that many emails off your own servers, you're almost certain to get yourself blacklisted. At

RE: CFML broadcasting app

2010-08-07 Thread UXB Internet
This is much bigger than a CFML issue... I could, and for the unfortunate bystanders, have talked for hours about the problem of email. We are a website design and Hosting company and yet my biggest expenditure in time and resources goes to email and email issues. - oops I started pontificating

Re: CFML broadcasting app

2010-08-07 Thread Mike Kear
As I understand it, the blacklisting services look NOT for large volumes of mail, but substantial and/or sudden changes. I had a spammer get through my defences once and set up hosting with me. Immediately he started sending volumes of email. Within 24 hours our ip addresses were blacklisted,