Re: [Axapta-Knowledge-Village] How this code can take 10 minutes to execute.Inventdim table has 4 million rows

Hi Serhad, this could only be the case when there is very poor communication network, and you are working on AOS 3 tier thin client system. but i will be helpful if you can give me some idea about the environment and the caching setup on the table . bye kumar

Re: [Axapta-Knowledge-Village] How this code can take 10 minutes to execute.Inventdim table has 4 million rows

take 10 minutes to execute.Inventdim table has 4 million rows static InventDim find(InventDimId inventDimId, boolean _forupdate = false) { InventDim inventDim; ; if (inventDimId) { inventDim.selectForUpdate(_forupdate); select firstonly inventDim