Ojs 3.2.1.2 because the tables submit_search_object_keywords and submit_search_keyword_list are too heavy

Description of issue or problem I’m having:

Because the tables submit_search_object_keywords and submit_search_keyword_list are too heavy in ojs 3.2.1.2
At the moment not many files are uploaded to the platform but it already weighs about 1 gig, and the problem is presented in the 2 tables submit_search_object_keywords and submit_search_keyword_list

It is version problem or because it is the problem.

please someone who can help me

Application Version - e.g., OJS 3.1.2:

1 Like

I’m not sure if I understand your question, but it seems you are asking why those two specific tables are that large.

That’s because every submission file uploaded to the system is parsed and its textual contents are extracted; then, every single word on every single file is indexed by saving them (and their references) on these tables, which are then used when a search is performed on the front-end.

1 Like