Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Best strategy for best performance
sp_NewPost Add Reply sp_NewTopic Add Topic
May 12, 2023
10:26 am
Henk Helmantel
Admin
Forum Posts: 1499
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

There 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

May 11, 2023
8:51 pm
Lucky
Guest
Guests

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?

May 8, 2023
9:55 am
Henk Helmantel
Admin
Forum Posts: 1499
Member Since:
May 28, 2013
sp_UserOfflineSmall 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

May 4, 2023
6:14 pm
Lucky
Guest
Guests

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?

May 4, 2023
3:12 pm
Henk Helmantel
Admin
Forum Posts: 1499
Member Since:
May 28, 2013
sp_UserOfflineSmall 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

May 4, 2023
4:46 am
Lucky
Guest
Guests

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?

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
8 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1148

Posts: 3923

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1499