Hi Seikath,
Postgress might be a bit on the heavy side for plain DLR storage. I tend to
agree with you about SQLbox being a better choice for DLRs.
Thanx for the input,
Nikos
----- Original Message -----
From: "seikath" <[email protected]>
To: "Nikos Balkanas" <[email protected]>
Cc: <[email protected]>
Sent: Thursday, January 15, 2009 11:03 PM
Subject: Re: DLR DB processing
sql and postgresql and rules on insert /its pgsql only feature/
set the sqlbox to handle MT and DLR and set the postgresql to allow like
2000 concurrent connections - you need some RAM for that ...
Nikos Balkanas wrote:
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