[FX.php List] [OFF] Slow response when sending PHP email?

[Bob Patin]

On May 9, 2013, at 1:32 PM, Joel Shapiro <jsfmp at earthlink.net> wrote:

> You don't see slower page loading when you include PHP mailing -- compared to the same page without emailing?  (or you just never checked?)  For me, adding in the mailing adds at least a couple/few additional seconds before the page will load.

Well, I've honestly never tested it, but the final page seems to load fairly quickly most of the time.
> 
> Yeah, I've also seen that adding multiple new records is probably the slowest thing with CWP, and also found that calling an FM script instead to do the record creation is a LOT faster.  (I even blogged about it :).  I haven't, though, tested this in FM12. Have you had a chance to see if adding multiple new records in FM12 is still really slow?

We moved to 12 about 6 months ago, but I still generate the large record sets using a script. On this particular site, there's one ticket type that requires generation of 12 lineitem records + the order itself, which is a LOT to do in CWP. For this one ticket type I pass off to FIleMaker and generate the records in a script.
> 
> And lastly, out of curiosity, why don't you like to email from FMS?

Well, I'm not a big fan of running scripts from CWP; for me it's a little harder to find errors, so I just prefer doing it from PHP. Maybe it's just from habit, or hard-headedness...

>  I've given up my earlier belief that everything has to be pure PHP, and have toyed w/ the idea of calling an FM script from the PHP to have FMS send smtp emails.  I do realize this puts an additional load on the DB server -- as opposed to on the Web server...

One of my clients' sites has some scripts that run at the conclusion of the process, and we had a lot of trouble finding issues with it. Generally, I try to keep web apps lean enough that a complex script isn't required; I'm about to rewrite a pair of sites that use scripts for sending emails, and I'm going to push for doing away with any script-firing this time around.


Bob Patin
Longterm Solutions LLC
P.O. Box 3408
Brentwood, TN 37024
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
AIM: longterm1954
Twitter: bobpatin
Google+: http://www.longtermsolutions.com/plus
--
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20130510/9d72f71b/attachment-0001.html