User Page takes forever to load OJS 3

[kaitlin]

Hi @Lazar_Stosic, it sounds like the issue is your database setting for MAX_JOIN_SIZE - do you know what your provider has it set to? It sounds like they need to increase it further.

I would also suggest reviewing these other threads which you commented on, which discuss this in more detail:

Database Error (DB Error)

We have a problem under editors role as we click the archives, we get the following message DB Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay The hosting service says, “the reason you see this error is because your query is (apparently) too big. Unfortunately, we cannot change this setting because it helps to protect our servers against queries which will take too much server power.” …

DB Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECT=1 or SET MAX_JOIN_SIZE=#if the SELECT is okay

I encountered this error when I’m Testing it Online in the editor section.