Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

Insert & Update to MessageLog is become very slow
sp_NewPost Add Reply sp_NewTopic Add Topic
November 28, 2016
3:35 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Sarfaraz,

The SMPPConnector.dll plugin that you use is a 32-bit plugin and it won't work on the 64-bit version of Diafaan SMS Server. The functionality that this plugin provides is already available in the SMPP Connector of version 4.0, it is therefore best to remove the plugin from the plugin folder of Diafaan SMS Server.

The most likely cause for a slow insert of the log items in the SQL database of the SQL Connector is that the MessageLog database table is getting too large. Inserting new messages in the log database is usually not a problem but updating the delivery status of the messages will take longer when the database grows because the query has to look up the record with the right message ID for each status update in order to update the record.

There is little you can do in Diafaan SMS Server that will speed up the database handling, the best way to keep up the performance is not letting the database get too large, for instance by moving older records to a different database. You can also have a look at the indexes of the MessageLog database table. If the indexes are not set to the right field(s) (at least 'MessageID'), looking up the records for the status update will take a lot longer than if the proper fields are indexed.

Regards, Henk

November 28, 2016
2:08 pm

Hello Henk,

We have Installed the new version 4.0 64bit on our server, we are also using one smppconnector.dll which you had given us via email. After doing the update with new installation we are saying some issues.

1. The MessageLog Insert & Update is become very slow.
2. Once we got the below error.
11/28/2016 12:32:51 PM (error) Diafaan SMS Server (service):
Could not load file or assembly 'file:///C:\Program Files\Diafaan SMS Server\Plugins\SmppConnector.dll' or one of its dependencies. An attempt was made to load a program with an incorrect format.

We can see that Diafaan SMS server is keeping the details in the ram but taking much time to insert & update that data to the SQL Database. We have 2 SQL Connectors one is set to update in 3 secs and other one in 5 secs but when we get a huge sent of 10000 and above then the insert & update becomes very slow. Please help us on this as it is creating alot of issue at our end.

Have a great day!!!

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
4 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: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502