Ir al contenido
Menú
Se marcó esta pregunta
2094 Vistas

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
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
0
mar 21
1902
2
mar 15
9701
0
jul 25
846
1
jul 25
692
0
feb 25
1800