OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



OJS database data retrieval delay

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
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

OJS database data retrieval delay

Postby kennymatthew » Tue Oct 29, 2013 2:17 am

Hi,

Recently I have been having issue when using the site to view pages that use the database to display data like enrollment or to download reviewers comments. Its been a year since we started using OJS is there some kind of maintenance we need to do ?
kennymatthew
 
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm

Re: OJS database data retrieval delay

Postby JasonNugent » Tue Oct 29, 2013 5:14 am

Hi Kenny,

Nothing specific to OJS, no, but there are useful utilities and commands you can run on your databases in general. Examine the 'analyze table' and 'optimize table' MySQL commands on the MySQL website. They can help keep indexes and keys in order.

Jason
JasonNugent
Site Admin
 
Posts: 910
Joined: Tue Jan 10, 2006 6:20 am

Re: OJS database data retrieval delay

Postby kennymatthew » Wed Oct 30, 2013 2:45 am

Hi Jason,

Thanks alot for the info. will check it out ...
kennymatthew
 
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 1 guest

cron