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
>
>
>
