Support forum
Add Reply
Add Topic10:26 am
May 28, 2013
Offline
QuoteThere is no general answer to this question, it depends on the HTTP API of the SMS service what the best solution is.
The generic HTTP Gateway does not have an option to receive delivery reports, handling delivery reports can only be achieved with a customized script in the HTTP Gateway or with.
Regards, Henk
8:51 pm
Finally we implemented mysql connector and it works well (around 500 sms/s).
What is the recommendation for importing delivery report for messages we send via http connector? (we don't want to use http callback directly to diafaan)
Think about a gateway script with a 1 minute timer to download a list of delivery messages (we can save them separately). Similar to the example scripts, the script for the regular test message is shown. Is this good way?
9:55 am
May 28, 2013
Offline
It is possible to use an SQLite database with Diafaan SMS Server, using an ODBC driver or a custom C# script. But SQLite is not a multi-user database and using it to send a large number of SMS messages to Diafaan SMS Server is not optimal and will likely lead to problems with database record locking.
At the moment we do not have plans for an extension to the HTTP API that allows adding multiple message in one HTTP request. If you are interested this option you can send us an email with this request and we will put it on the list for future versions. Please include the serial number of your license in the feature request.
Regards, Henk
6:14 pm
I understand. But that mysql database is relatively complex. If I could use sqlite it would be simplier.
The easiest way would be to add bulk upload support for the http api and having the ability to send say 1000 separate messages in one http request.
Is this feature planned?
3:12 pm
May 28, 2013
Offline
Hello Lucky,
The best option for sending large amounts of messages with Diafaan SMS Server is to use an SQL Connector, preferably with a local multi-user database like Microsoft SQL Server (Express) or MySQL. You can then simply send the messages by adding them all to your database in one transaction. The SQL Connector also has an option 'SendQueueThreshold' to pause the import of messages from the database when the send queue of Diafaan SMS Server has a certain number of messages so that the send queue in Diafaan SMS Server does not get too large.
The other options are feasible as well but they are slower.
Regards, Henk
4:46 am
Please advise me on the fastest way to send 3 000 000 messages (I mean, just how to send them to Diafaan).
a) I can use the command line interface and insert messages one at a time / or insert them asynchronously
b) I can use http interface and insert one message at a time / or insert them asynchronously
c) I can use the Excel interface and create batches of e.g. 100 messages. Or more?
Is there a difference between option a) and b)?
Will option c) be faster?
Most Users Ever Online: 529
Currently Online:
5 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 672
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1141
Posts: 3899
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1488