Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve GET/Count based on base table view instead with translation #227

Open
norbertbede opened this issue May 3, 2024 · 1 comment
Open

Comments

@norbertbede
Copy link

example
when i run get query against table fv_m_product the rest api start a count operation. but i would say absolutely unnecessary do thos over _vt table (if table has translations)

produced SQL

SELECT COUNT(*)
FROM fv_m_product_VT
WHERE  AD_Language = $2)
AND   IsActive = $3 
AND   fv_m_product_VT.AD_Client_ID IN ($4,$5)

example
100k products witht 5 languages = 500k records, whoch costs much more then count over 100k

proposal
improve rest count on translation tables isview='Y' use base table for count instead translated view in database }_vt)

@norbertbede
Copy link
Author

tested by cloudempiere
rest-227-count_notrl.patch

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant