Hi Alvaro,
Thanx for your detailed reponse. I am interested only for DLR storage at the
moment. In that case queries are not my issue, since kannel will handle them
internally.
I have heard good things about sqlbox that it was especially good for DLRs.
As far as performance, I am thinking that DLRs share the same thread as
regular SMS. Therefore if they delay too much they will affect SMS
performance as well.
For light jobs (plain vanilla DLR storage) a lighter DB makes sense. Mysql
is known to have an issue with locking the whole table on an insert, where
as other databases lock only the row (i.e. Oracle).
BR,
Nikos
----- Original Message -----
From: "Alvaro Cornejo" <[email protected]>
To: <[email protected]>
Cc: "Nikos Balkanas" <[email protected]>; <[email protected]>
Sent: Thursday, January 15, 2009 11:15 PM
Subject: Re: DLR DB processing
Hi Nikos
I think your question is somehow subjective. Most of the DB are stable
and fast/reliable enough to handle bulk messaging.
The issue I thinks is on 2 aspects: The HW itself and its
configuration and the SW configurations.
If you do know well any of the mentioned DB, you set your Queries with
care, you can get millions of transactions per minute; however if you
go for a db you don't or barely know, thus your queries are not
"optimal", transactions per minute might be highly inefficient.
From the HW perspective about the same, if you have a lot of
CPU/RAM/Disks etc and the OS is not configured correctly no DB will
work properly, nor the system will be reliable.
I have a Dell1950 2CPU Coreduo, 2GB Ram & 360Scsi disks under fedora
6. I run kannel, mysql5, php, apache2 and my php application on it
with no problem since more than 2 years.
Hope Helps
Alvaro
|-----------------------------------------------------------------------------------------------------------------|
Envνe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perϊ, Mιxico y en mas de 180 paises. Use aplicaciones 2 vias via
SMS y GPRS online
Visitenos en www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com
2009/1/15 <[email protected]>:
Hi Nikos,
I went poorly programming daemon which acquired DLR communicates in PERL,
on
the other hand, PHP script has been a bottleneck. Currently, with access
to
the oracle database and a bit of experience in the pl/sql I use oracle and
mod_owa with apache, performance is suitable for me - I am able to take
about 1000 DLRs within a few seconds. Also it is a convenient solution -
all
logic DLR of receiving can be drawn by oracle procedure.
Regards,
Jarek Guzik
________________________________________
From: Nikos Balkanas [mailto:[email protected]]
Sent: Thursday, January 15, 2009 7:03 PM
To: [email protected]
Subject: DLR DB processing
Hi,
I am considering using a DB for DLR storage. Up till now I was using
internal DLRs. Of the many options supported, (Mysql, PostgresSQL, Oracle,
LibSdb, sqlbox, sqllite) which one would you consider best suited for bulk
SMS, in terms of performance and reliability. If you could also give a one
liner for your choice, it would be most appreciated. I thing it is fair to
say, that internal is the fastest and least reliable of all.
Thanx
Nikos
