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.
kennymatthew
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm

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 ?

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

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

kennymatthew
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm

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 ...


Return to “OJS Technical Support”

Who is online

Users browsing this forum: Google [Bot] and 2 guests