php - High CPU usage when using cron job and sending emails -

-

i have website sends daily writing reminders users based on timezone , hour settings. eg: user in new york (america/new_york) prefers receive reminder @ 9pm. in current implementation (after many changes), store timezone , notify_hour in settings table , find users complex , heavy mysql query.

the query slow, added indexes , made faster. after find users try send emails through external smtp server (sendgrid.com). ive set cron job run every 10 minutes , check 200 users. have 2000 active users. works fine this. of users located in iran (asia/tehran) , of them have selected 9pm receive reminder. peak hour between 8pm , 11pm irst.

but server admin says cron job uses cpu. 25% high. tried debug script, query fast when comes sending emails through smtp server, takes longer:

email reminder has been sent 4 people - query: 0.75444 seconds ---- system: 11.18443 seconds. ----  email reminder has been sent 0 people - query: 0.65488 seconds ---- system: 0.68821 seconds. ----  email reminder has been sent 5 people - query: 0.75551 seconds ---- system: 3.45176 seconds. ----  email reminder has been sent 1 people - query: 2.37117 seconds ---- system: 9.05586 seconds. ----

first number how long query took , second time whole system load.

this script use cron job: http://pastebin.com/eee3lzys
mailer class connects smtp server on construction , sends email on each iteration of script. (sorry english!)

can suggest better way achieve whole thing or minimizing cpu usage or something?
thanks.

please not insert in loop 

foreach($users $k => $v){

use multi raw insert fast other sql query pefomance depends on data on live server.


Comments

Post a Comment

Popular posts from this blog

objective c - Change font of selected text in UITextView -

-
can suggest me how change font of selected text in uitextview.i cannot use uiwebview since have edit text. have seen pages app.how possible in app. see formatting text within uilabel differently . since need editing, should @ javascript-based editors such ckeditor or tinymce . highly recommend wwdc 2011 video session 511: "rich text editing in safari on ios."
Read more

php - Accessing POST data in Facebook cavas app -

-
so i've got simple form in canvas / iframe facebook app, , i'm trying pass along values post. reading on s.o. , fb's latest docs, understand it, data send via post form can accessed on receiving end $_request object. i read on thread on s.o. in order post forms work need pass along input named "signed_request" value current signed_request (i have signed request working ok otherwise...all login , authentication stuff working fine). isnt mentioned anywhere in official fb docs. so problem comes in $_request object signed request, , bunch of other session stuff. form inputs found. the way can read them set method of form "request" isn't real form method. takes of inputs , sends them args in url. horrible. here's sample page canvas app form i'm using try debug (leaving out authentication stuff): <form enctype="application/x-www-form-urlencoded" method="post" target="_top" id="my_form" action=...
Read more

c# - Getting control value when switching a view as part of a multiview -

-
i have following code in aspx page: <asp:button id="display_button" runat="server" text="display" onclick="button1_click" /> &nbsp; <asp:button id="edit_button" runat="server" text="edit" onclick="button2_click" /> &nbsp; <asp:button id="save_button" runat="server" text="save" onclick="button3_click" visible="false" /> &nbsp; <asp:multiview id="multiview1" runat="server" activeviewindex="0"> <asp:view id="view1" runat="server"> <asp:formview id="view_program" runat="server"> <itemtemplate> <%# eval("status").tostring().trim() %> </itemtemplate> </asp:formview> </asp:view> <asp:view id="view2" runat="server"> ...
Read more