robustness of OJS (searching)

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
The Public Knowledge Project Support Forum is moving to

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.
Posts: 2
Joined: Sat Oct 15, 2005 12:07 pm

robustness of OJS (searching)

Postby romca » Wed Oct 19, 2005 11:50 pm

Hi all,

I am trying to investigate if OJS is a good choice for e-journal Ikaros. The journal exists for nine years and there are virtually thousands of articles (do not know the exact number, but there could be about 2.000 articles, and that is still not everything - there are comments, special issues, short news and other, see ).

As I know that searching with PHP makes the index extremely big and sometimes performace may be an issue, I would like to ask you your opinion (I also have not seen any OJS e-journal yet that would have as many vols/issues as Ikaros)

There is a short discussion on searching with a link to some more information, unfortunately, bugzila is probably not working

The journal should be placed on some shared webhosting, I can not believe that processor's time will be exclusively dedicated to us, so what do you think? Is OJS searching able to work with thousands of articles without performance penalty?

thanks for any comments/help


Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Postby asmecher » Thu Oct 20, 2005 10:39 am

Hello Roman,

The discussion at relates to a missing index; this can be corrected by executing the following in MySQL:

Code: Select all

CREATE UNIQUE INDEX article_search_keyword_text ON article_search_keyword_list (keyword_text);

With this index in place, we currently know of no performance issues with OJS 2.x's searching and indexing. A number of OJS 2.x journals are available for browsing at if you'd like to assess for yourself.

OJS 2.x has been deployed in many shared hosting environments without issue.

Alec Smecher
Open Journal Systems Team

Posts: 2
Joined: Sat Oct 15, 2005 12:07 pm

link, data?

Postby romca » Thu Oct 20, 2005 12:02 pm

Hello Alec,

thank you - now I see that the code is for building an index in MySQL (for faster queries).

I have also gone through many OJS installations, but never seen any with that many (say at least 20) issues. Almost all OJS installations were quite fresh (at least what I have seen).

I would be grateful if you could post some link, or maybe, you developers, have already tried a configuration with many many articles, did you?

The task of exporting/importing data is stil ahead, so I can not try it myself now, I am sorry. It would definitely be easier to use OJS search ability, but if it can not deal with thousands of articles, I will have to employ an external search engine - this is also one point of evaluation criteria.

thank you


Return to “OJS Editorial Support and Discussion”

Who is online

Users browsing this forum: Baidu [Spider] and 2 guests