I am developing a site using Omeka-S 3.2.3 . I’ve noticed up to a minute of lag-time when bringing up the admin New Item or Edit Item screens.
Reading some of the other topics here about slow performance turned me on to the usefulenss of enabling the general log as a table in MySql/Mariadb. This can be done by typing a couple of SQL commands into Adminer or other MSQL front end. The general_log can be piped to a general_log table in the mysql database, which records all of the queries that are processed by the database server.
In my case, I see that the following query is being issued in identical form more than 1000 times while Omeka-S is trying to load the Edit Item page.
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.created AS created_4, t0.modified AS modified_5, t0.password_hash AS password_hash_6, t0.role AS role_7, t0.is_active AS is_active_8 FROM user t0 WHERE t0.id = 3 AND t0.is_active = 1 LIMIT 1
It seems to have something to do with authentication. I have not gotten around to hooking up my Omeka to SMPT yet, which might be part of the problem.
I’ve tried searching through the Application/src directory for strings that may be related to this, without any luck.
Any help for me today? Thanks .