Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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?
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden| Gerelateerde posts | Antwoorden | Weergaven | Activiteit | |
|---|---|---|---|---|
|
0
mrt. 21
|
1993 | ||
|
2
mrt. 15
|
9819 | ||
|
0
jul. 25
|
1023 | ||
|
1
jul. 25
|
865 | ||
|
0
feb. 25
|
1911 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
