Performance issue

If you think that something doesn't work in Aware IM post your message here
Post Reply
jannes
Posts: 101
Joined: Tue Jul 02, 2019 12:22 pm

Performance issue

Post by jannes »

I have a serious performance issue.

Just doing 1 simple update in the AIM-application generates almost 12.000 SQL-statements ... :cry:

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 ??
Attachments
Naamloos.jpg
Naamloos.jpg (117.05 KiB) Viewed 4425 times
Post Reply