I have a serious performance issue.
Just doing 1 simple update in the AIM-application generates almost 12.000 SQL-statements ...
The steps to see these SQL-statements are :
Step 1) Start AwareIM application. Go to the form.
Step 2) In MariaDB :
SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';
Step 3) AwareIM application
Change just 1 field in the AwareIM application
Save the record
Step 4) Maria DB
SET GLOBAL general_log = 'OFF';
select * from mysql.general_log
It reports 11.900 rows !!
See attachment.
I'v ticked "Don't check referred" in almost all business rules.
ps.
There is only 1 user (= me) on the server
What is causing all these SQL's ??
Performance issue
Performance issue
- Attachments
-
- Naamloos.jpg (117.05 KiB) Viewed 15188 times