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
SQL connector max queue length
sp_NewPost Add Reply sp_NewTopic Add Topic
October 31, 2016
1:22 pm
Henk Helmantel
Admin
Forum Posts: 553
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

If you install the new version over an existing installation, all settings are preserved. And the installer won't let you finish the upgrade if your license is not valid for the new version of Diafaan SMS Server anymore.

There is of course always a chance that the upgrade goes wrong or that a new function or setting changes the way your configuration works. In a production environment it is best to do the upgrade in a quiet period. You can also make a backup of the following folders and restore the backup when something goes wrong:

- C:\Program Files (x86)\Diafaan SMS Server\ or C:\Program Files\Diafaan SMS Server\
- C:\ProgramData\Diafaan\Diafaan Message Server\

We do not have a phone number for support, if something goes wrong the fastest way to contact us is by email of through this forum.

Regards, Henk

October 31, 2016
12:27 pm
Mahmoud Abd El-Fatta
Guest
Guests

Thank you So much Henk,

One last question :), if I install the latest version now, will I need to reconfigure all gateways and connectors ? or it will work normally with the current configurations?

Also, this is a production environment. So, if the license does not work on the new version, is there a support number that I can call to solve any issues ?

Thank you,
Mahmoud

October 31, 2016
11:45 am
Henk Helmantel
Admin
Forum Posts: 553
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

The 'SendQueuePauseThreshold' option was introduced in version 3.3.0.0 of Diafaan SMS Server, your license allows a free update to the latest version of Diafaan SMS Server. To upgrade, you can download the latest trial version of Diafaan SMS Server from our website and install it over your current installation.

If the server that runs Diafaan SMS Server is powerful enough, 300.000 records in the send queue should not be a problem. But if the hard disk is relatively slow or if the messages routing rules that you set up in Diafaan SMS Server are complicated then processing the messages in Diafaan SMS Server might be getting slower with 300.000 records in the internal send queue database.

Best regards, Henk

October 31, 2016
11:22 am
Mahmoud Abd El-Fatta
Guest
Guests

Hello Henk,

Thank you for your reply.

Unfortunately, I can't find the 'SendQueuePauseThreshold' setting in the SQL connector. I'm using version 3.0.0, was this available then ?

Also, I'm using SQL server 2012 and a very powerful server that can handle a million records table easily.

So, if I add a 300k records, the send queue will work normally if the server is powerful enough ?

Thank you,
Mahmoud

October 31, 2016
10:06 am
Henk Helmantel
Admin
Forum Posts: 553
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Mahmoud,

If you send very large batched of messages from the SQL Connector you can set the 'SendQueuePauseThreshold' in the advanced settings of the SQL Connector to limit the amount of messages that are imported by the SQL Connector. This setting pauses the import of messages from the database when the send queue exceeds a specific number of messages. A value of 10000 or lower will be adequate for all configurations, even on slow servers. This option only works on databases that support a LIMIT or TOP keyword in the SQL request like Microsoft SQL Server, MySQL or Oracle.

Diafaan SMS Server does not have a hard limit for the amount of messages in the send queue, but there is a practical limit where the number of messages in the queue slows down the message processing in Diafaan SMS Server. We test Diafaan SMS Server with up to 1.000.000 messages in the send queue and make sure that this works well on our test servers, but on servers with slower hard disks or in configurations with complicated message routing the practical limit may be lower.

Regards, Henk

October 30, 2016
12:37 pm
Mahmoud Abd El-Fatta
Guest
Guests

Hello Henk,

I'm using SQL connector and things seem to be working fine. Sometimes, I enqueue a batch of 60k messages and they go directly to the send queue with no problems.

I some cases, I will be required to send batches larger than 60k and sometimes reaching 300k.

Is this OK for the queue ? I couldn't find any setting regarding the maximum queue length [ I'm using version 3.0.0 licensed for 4 gateways and 4 connectors]

Thank you,
Mahmoud

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
12 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 364

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 532

Posts: 1847

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 553