Very slow user list update (OJS 3.2.1-1)


After I updated my OJS for the version 3.2.1-2, the function Users are so slow. In the past it was slow, but now it is impratical.

To load the user list (limit of 100) I lost 40 seconds. For a specific search, a lot of minutes.

Please guys, any suggestion?

Update: My DB have something like 20k users.

I fixed it with @asmecher hint:

I created the index in the database and it works:

CREATE INDEX user_settings_setting_name_index ON user_settings (setting_name);

Thank you @asmecher

1 Like