System database
Storing great numbers of messages in files can slow down
your system especially when messages need to be read/imported before sending.
To avoid this
issue you can use System Database option of Ozeki NG SMS Gateway that will
store all messages in a database instead of a file. In this way you can
speed up sending of great numbers of messages.
Please read how you can import messages into a database:
System Database Importer
To configure System Database option go to Edit
menu and select Server Preferences sub-menu in Ozeki NG SMS Gateway
(Figure 1).
Figure 1 - Server Preferences
Click on Databases tab and select System database
settings. Here enable Use database server instead of file system to
store message option. Then specify Database connection
type and Database connection string and provide the following
parameters (Figure 2):
If you wish to use MySQL as the system database please configure the following
SQL templates in the Server preferences form:
Create
CREATE TABLE IF NOT EXISTS $tablename (`messageid` VARCHAR(60) NOT NULL,
`createdate` DATETIME NULL,`serializedmessage` TEXT NULL,PRIMARY KEY(`messageid`));
|
Load index
SELECT messageid FROM $tablename
|
Load
SELECT messageid,serializedmessage FROM $tablename WHERE messageid IN ($idlist)
|
Save
INSERT INTO $tablename (messageid,createdate,serializedmessage) values ('$messageid',now(),'$serializedmessage')
|
Delete
DELETE FROM $tablename WHERE messageid IN ($idlist)
|
Move
INSERT INTO $tablename (messageid,createdate,serializedmessage) SELECT messageid,
createdate,serializedmessage FROM $sourcetable WHERE messageid IN ($idlist)
|
Find old
SELECT messageid FROM $tablename WHERE createdate<DATEADD(now(), INTERVAL -$maxage SECOND)
|
Delete old
DELETE FROM $tablename WHERE createdate<DATEADD(now(), INTERVAL -$maxage SECOND)
|
Figure 2 - System database settings
Please note:
When you switch to System Database, you can receive an error
message since the system cannot find messages.
The reason for this: the system searches for messages still in the file but
system database stores them in a database. To avoid this error message please
read How to import messages into system database.
Dig deeper!
People who read this also read...
How to import messages into system database
Next page:
Oracle configuration
| 
