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

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: 849
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: Yahoo [Bot] and 12 guests