Our journal is currently using the OJS system (so far, it has published approximately 1,000 articles. There are a total of over 4,000 published and unpublished manuscripts in the system). However, each time you visit the submission page, it takes 1 to 5 minutes. This has largely affected the speed at which our editors process the manuscripts. After being tested by IT experts, it was found that when this interface was accessed, the server would perform 14,000 SQL queries from MySQL, reading approximately 30MB of data, which resulted in a processing time of over ten seconds. Is there any way to optimize the speed of SQL queries?
For now, we are using OJS 3.4.0-4
And the page link shows below:
https://repqj.com/index.php/repqj/submissions
And some test screenshot shows below.
Thank you for your help
Hi @xden0006,
OJS is known to execute a lot of SQL statements, and this can affect performance on large datasets, particularly in cases where the database server is not hosted on the same machine as the application.
If your database server is not on the same machine as the application, I would suggest moving it there – you’ll immediately see a significant performance improvement.
Meanwhile, we are working gradually on improving performance by applying a variety of improved storage layer techniques. Significant work is already included in OJS/OMP/OPS 3.5.0, which was very recently released and will become our next LTS (Long-Term Support) line of releases. However, this isn’t a 100% complete solution, as at least one user with a very large database has reported performance issues with 3.5.0.
Any improvements we do make – short of something trivial like adding an index on a table – will be to 3.5.0 or 3.6.0. I’d suggest testing 3.5.0 to see if it offers some improvement, as a starting point.
Regards,
Alec Smecher
Public Knowledge Project Team
Hi, asmecher,
thank you for your answer. Just wonder if there is a way that once the editor entered the submission page, the database only search the latest several dozen submitted manuscripts instead of going through the entire database.This is extremely helpful for a journal that has received tens of thousands of submitted articles. 
Unfortunately, we did use the same server to operate the database and application, and I’m certain that there are no problems with our network. However, we still have to endure the anxiety of having to wait for about a minute each time we access the submission page. 
You can limit the number of items displayed in Website > Tab Setup > Lists > Field Items per Page.
See Group archive issues by year - #13 by kerimsarigul and the following post if you want to distinguish between maximum number of submissions displayed and maximum number of issues displayed.
Hi Mr. Mpbraendle, I have double check the seting of list. The items per page is 10 and page links is 3(shows inside the image). However, the inside the submissions page, the list of submission is 30 and the speed is still slow. Is there any bug exists?
This topic was automatically closed after 16 days. New replies are no longer allowed.
