OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Performance OJS with large amounts of data

OJS development discussion, enhancement requests, third-party patches and plug-ins.

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

Forum rules
Developer Resources:

Documentation: The OJS Technical Reference and the OJS API Reference are both available from the OJS Documentation page.

Git: You can access our public Git Repository here. Comprehensive Git usage instructions are available on the wiki.

Bugzilla: You can access our Bugzilla report tracker here.

Search: You can use our Google Custom Search to search across our main website, the support forum, and Bugzilla.

Questions and discussion are welcome, but if you have a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a technical support question, try the OJS Technical Support subforum.

Performance OJS with large amounts of data

Postby jamil » Tue Feb 09, 2010 3:05 am

Hello Guys,

Work BIREME where we have an installed OJS to 47 magazines, with nearly 20,000 articles, the performance problem is occurring at the time of listing the articles by the editor, the response time for this action is almost 1 minute.

We analyzed the number of queries to the database and found a very large number of queries, about 2500.

The server has a large processing power and memory.

Does anyone have any idea why so many queries to build a list pages.

Thanks

[b]Jamil Atta Junior
jamil
 
Posts: 4
Joined: Mon Feb 08, 2010 7:04 am

Re: Performance OJS with large amounts of data

Postby asmecher » Tue Feb 09, 2010 11:03 am

Hi Jamil,

You can try the patches at http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=4737; these will optimize the Editor's interface considerably.

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

Re: Performance OJS with large amounts of data

Postby jamil » Wed Feb 10, 2010 2:56 am

Hi Alec Smecher,

our version is 2.2.1.0 we can applie this patch?

Thanks,

Jamil Atta Junior
jamil
 
Posts: 4
Joined: Mon Feb 08, 2010 7:04 am

Re: Performance OJS with large amounts of data

Postby asmecher » Wed Feb 10, 2010 10:51 am

Hi Jamil,

Unfortunately not directly -- the patch was written for OCS 2.3. Back-porting it will not be a massive task, however; you'll need e.g. to change the "authors" table in the query to "presenters" and the respecitive "author_id" to "presenter_id", and likely a few other things.

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

Re: Performance OJS with large amounts of data

Postby jamil » Tue Mar 02, 2010 12:01 pm

Alec Smecher,

Is this problem of performance correct in new version (2.3.1-2) ?

Thanks

Jamil Atta Junior
jamil
 
Posts: 4
Joined: Mon Feb 08, 2010 7:04 am

Re: Performance OJS with large amounts of data

Postby asmecher » Tue Mar 02, 2010 2:15 pm

Hi Jamil,

No, the patch linked above is not shipped with OJS 2.3.1. You can apply it to your 2.3.1 installation using the GNU patch tool if you like.

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

Re: Performance OJS with large amounts of data

Postby Pat » Thu Apr 08, 2010 12:30 pm

Two questions for performance problems:
a) After the long discussion above - is the indexing change now the only modification that is needed, or do the multiple patches mentioned in Bug 4737 need to be applied anyway ? In 2.3.1.1 only ? Also in 2.3.1.2 ?

b) in our OJS 2.3.1 on Windows, PHP5, we experience slow performance, too, but we do not have large amounts of data in our young journal. Is performance on 2.3.1.2 less an issue, with/withouth the mentioned patches and the indexing modification?

BTW: patching on windows hosted providers without command-line access is a pain, needing to FTP all the decompressed distribution files to the server. Would it really be impossible to give the OJS site manager an option to upgrade from "within" the system to the current version ? At least, typo3 can do it, too.

Thanks for the great system !
Pat
Pat
 
Posts: 12
Joined: Tue Mar 04, 2008 1:59 am


Return to OJS Development

Who is online

Users browsing this forum: No registered users and 2 guests