Assuming he wanted to avoid a DB hit altogether really, but yep sqlbox
should do that (no personal experience).
On 07/10/2014 20:47, Rene Kluwen wrote:
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
<mailto: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 <mailto: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 atkyria...@netsmart.com.cy <mailto:kyria...@netsmart.com.cy>
**
--
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 **
