As a default Ozeki SMS Gateway stores messages in files. Storing large amount of texts in files can slow down you system. It is highly recommended to switch to the System Database option, which will definitely speed up SMS Gateway. Here you can see how to add your Oracle database.
If you are uncertain how to import messages from your files, you can look back and see how to switch from file to database. It is a short site to scroll through. The diagrams will help you understand.
Steps of configuration
From the 'Edit' top menu, please select 'Server preferences'. A window demonstrated on Figure 1 will appear. Select 'System database settings' tab and enable 'Use a database server instead of file system to store messages' option. Set the connection type to OleDb.
Keep in mind that you should provide the connection string as well.
You will find 9 different tabs. From the codes below you can copy-paste the content to each tabpage.'Create' tab:
Code 2 - Creates database table
'Load index' tab:
Code 3 - SELECT -s all message ID -s from your table
Code 4 - Loads message with the help of the message ID
Code 5 - INSERT -s serialised message into table
Code 6 - DELETE -s message from table where ID is in the ID list
Code 7 - INSERT -s message from source table into target table
'Find old' tab:
Code 8 - Find old messages with a simple SELECT
'Delete old' tab:
Code 9 - Delete old messages from the table
Code 10 - UPDATE message records having the preferred message ID