The users are using a classic client customized form and perform queries on it.
This form is basically looking at two ledger entries tables. So when the users enter a value then it queries customer ledger table and other ledger table same time.
This is slow. There always been users performing queries on Customer ledger entries form directly to look for posted invoices etc. While there are other uses who post invoices. Is it fine to let the users query customer ledger entries form? Or there can be better way please help?