OCS paper_search_object_keywords why is too huge?

Software Support
1

I noted in the database the table “paper_search_object_keywords” it is the bigger table in the DB. Probably is the 50% of all DB.

Coulbe set to be smaller? Or deactivated?

Best Regards
Alessandro

2

Hi @it_staff_euroturbo

That table contains the full-text inverted index for searching, so it can grow quite large if you index a lot of content. If you want to remove full-text from it, you could disable the text extraction tools in config.inc.php and then run php tools/rebuildSearchIndex.php to regenerate the index accordingly.

Regards,
Alec Smecher
Public Knowledge Project Team

3

Dear Alec
I can’t execute php tools/rebuildSearchIndex.php NO access to CLI, there is other way? Acron manage the re-build?

Is there a way to execute this script via web?

Best Regards

Alessandro

4

Hi @it_staff_euroturbo,

Unfortunately that script needs to be run from the command line; it may need to run for hours, and servers will rarely allow web-based requests to run that long.

Regards,
Alec Smecher
Public Knowledge Project Team