Memory requirements for 5.0.2?

[RVice]

I've upgraded from 4.x to 5.0.2 and noticed things are very slow. Is there a minimum memory requirement? I'm on a shared hosting server, and I know I had to request a memory bump from 128 MB to 512 MB before. Has memory gone up? Or is this just due to MySQL being slow (i do see a timeout there once in awhile).

Looking at the MySQL analysis it also indicates 12 requests per second and suggests adding a cache for the requests. Is this advised, if so I'll see how I can get my host to enable that. Any other performance suggestions?

I'm also using the membership fee plugin and these slowdowns really make it inefficient to use.

[RVice]

I did a little more digging as to my slowness issue. I uncovered one part in loading the initial contacts page, the jquery within contacts.php takes ~30 seconds to load for 6.5 kb of data. This seems excessive.

Also, making edits to the date ranges on contacts roles, does not show any form of an edit occurring on pressing OK and the fields don't change for a significant amount of time and sometimes not at all, requiring reloading the form.

Is this indicative of a slow server/DB or normal?

[fasse]

If you want to get the real times for database SQL queries you can activate the debug mode https://www.admidio.org/dokuwiki/doku.p ... debug_mode (but in a productive system only for a short time) and than have a look at the generated log. There all SQL queries are logged and also the execution time. This should be for all SQL some milliseconds and not more. In my case with a local database all SQL queries are around 0,1 up to 25 milliseconds not more.

[RVice]

Queries are indeed fast as mentioned. However, I'm seeing 503 errors on the responses. This makes the page behavior very odd, particularly loading the Role information or even loading a members profile.

I suspect this is more "server" related. From time to time I get 503 when changing to the roles view:

./modules/profile/profile_function.php?mode=reload_current_memberships&user_uuid=###
./modules/profile/profile_function.php?mode=reload_former_memberships&user_uuid=###
./modules/profile/profile_function.php?mode=reload_future_memberships&user_uuid=###

Would be nice to show a loading screen also when making updates. When editing dates of a role and clicking OK, there's no indicator if it worked or not. OK sometimes stays around for a long time.

Also, clicking "Change Roles" multiple times, will load up multiple dialog boxes. I can see the queries queued within the debug console of the browser as well. Should probably only allow one load

[RVice]

I did a little more digging, seems like my web host is indicating it is script related. There are no CGI errors and it just takes a long time to load the roles pages (and even the profile picture).

I changed from PHP 8.4 to 8.3 and it does run a little faster. Not sure if it's just timing or if it truly is making a difference.