Skip to Content
Menu
This question has been flagged
2096 Views

Hi,

I notice that this query takes about 10 seconds on our odoo 12 installation.


SELECT count(u.*)
FROM res_users u
WHERE active=true AND
share=false AND
NOT exists(SELECT 1 FROM res_users_log WHERE create_uid=u.id);


Can I somehow optimize it? For example with an database index?

Avatar
Discard
Related Posts Replies Views Activity
0
Mar 21
1902
2
Mar 15
9711
0
Jul 25
863
1
Jul 25
698
0
Feb 25
1802