How big is your daily DLR volume? My suggestion is to tune up your DB, either the engine (MyISAM to InnoDB maybe) or configuration. Also I want to know how will you store the DLR? Parsing Kannel’s log? Save it to plain text? When you do the bunch or batch will it still update the DB? Then it will double the load, it will eat your DB and also the IO (if you parse the DLR from plain text) Please address this kind question to user’s list rather than devel’s list. Thanks
Willy Mularto SMS Gateway, Content Provider, Mobile Solution Specialist M: +62811923464, +62818923464 PIN BBM: 74924429 On Oct 3, 2014, at 6:55 PM, Vikas Wasiya <vi...@hostnsoft.com> wrote: > Hello, > > We have certain queries related to kannel dlr reports. > > We do not want Kannel to call our URL and delete delivery reports from Spool. > > Instead, we want to pull the delivery report in bunch and delete. > > Reason: reducing our DB load because every URL runs the update query on our > DB. > > > > Thanks and waiting for your reply, > > -- > Thanks & Regards > Vikas Wasiya > Sr. Software Developer > Walkover Web Solutions | HOSTnSOFT
