OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



very slow loading of some pages in ojs

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

very slow loading of some pages in ojs

Postby MaryamMohammadi » Tue Mar 11, 2014 12:21 am

Hi I am administrator of a Journal management system which uses ojs, now our system has about 60 journals , and for example one of these journals has 308 articles in review tab, and this page loads very slow about 10 sec to complete loading, what can i do ? Can i optimize the related query? or upgrading smarty? because I guess it's because of smarty, so I executed the query in php myadmin seperately , It doesnt take 10 secs to give answer
Thanks
MaryamMohammadi
 
Posts: 6
Joined: Sun Oct 21, 2012 4:51 am

Re: very slow loading of some pages in ojs

Postby asmecher » Tue Mar 11, 2014 8:11 am

Hi MaryamMohammadi,

What version of OJS are you using?

This likely is a slow database query or set of queries -- there's more than one query to look at for each page. Turning on "debug" in config.inc.php will show you all the queries that go into making up a page (note that all users will see these while the setting is on).

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8860
Joined: Wed Aug 10, 2005 12:56 pm

Re: very slow loading of some pages in ojs

Postby MaryamMohammadi » Wed Mar 12, 2014 12:05 am

Hi
Thanks for your answer
we use ojs 2.3.5
you mean this slow loading is not related to Smarty, and it's just because of the query?
MaryamMohammadi
 
Posts: 6
Joined: Sun Oct 21, 2012 4:51 am

Re: very slow loading of some pages in ojs

Postby asmecher » Wed Mar 12, 2014 9:50 am

Hi MaryamMohammadi,

OJS 2.3.5 is quite old; I would suggest considering an upgrade before debugging performance problems further.

You could consider configuring MySQL's "slow query log" to find out what the performance problem is; I'm fairly sure (though I could be wrong) that the problem will be a slow MySQL query or set of queries.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8860
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 9 guests