Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2405 Tampilan

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
Buang
Post Terkait Replies Tampilan Aktivitas
0
Mar 21
2220
2
Mar 15
10098
0
Sep 25
1
4
Sep 25
1414
0
Jul 25
1341