The database performance will be improved from the following aspects:
-
Choose proper database driver. Refer to Recommended database driver in Database performance settings for details.
-
Set reasonable timeout settings. Refer to Command Timeout in Recommended database setting for details.
-
Optimize the table structure.
-
Use proper index.
-
Optimize SQL statements.
