[OMP 3.3.0.13] Publishing is very slow

Hello,

I’m using OMP 3.3.0.13. I’ve getting problems with the publication process, that is so slow, taking more than 5 minutes.

Enabling the database debug option to debug just one monograph publication, I found:

1.423.579 times “INSERT INTO submission_search_object_keywords”
1.423.579 times “SELECT keyword_id FROM submission_search_keyword_list”

I think that is because I have large publication files of my monographs.

In this publication, I have:

1 PDF file 17.3MB
1 EPUB file 43.2MB
1 HTML file 152MB

The upload process is going smoothly despite the size of the files. The problem is in the publishing process, that is too slow.

I have only 11 monographs published and this is the size of my keyword tables:

[submission_search_object_keywords] - 139MB
[submission_search_keyword_list] - 56.5MB

My doubt is. Have a way to disable the files metadata mapping proccess on OMP? I think would be a way to bypass this.

Thanks!