If you use sqlbox, they will be inserted in the log table and you can select them any time afterwards.
From: users [mailto:users-boun...@kannel.org] On Behalf Of Kyriacos/Netsmart Sent: maandag 6 oktober 2014 11:58 To: Vikas Wasiya Cc: kannel users@kannel.org Subject: Re: Can we pull DLRs instead of PUSH by kannel? If the DB hit is the big issue and not the URL call, then simply have that URL write the DLRs in some serialized file that will allow easy processing latter. Still is probably more efficient overall to just push them to a DB table without processing, and then pull them from that for processing latter. Kyriacos On 06/10/2014 04:25, Willy Mularto wrote: 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 -- Kyriacos Sakkas Development Team Netsmart Tel: + 357 22 452565 Fax: + 357 22 452566 Email: kyria...@netsmart.com.cy http://www.netsmart.com.cy Taking Business to a New Level! ** Confidentiality Notice: The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution, or copying of this email message is strictly prohibited. If you think that you have received this email message in error, please email the sender at kyria...@netsmart.com.cy **
