Very slow user list update (OJS 3.2.1-1)

Software Support
,
1

Hi,

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?

2

Update: My DB have something like 20k users.

3

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

3 Likes