AnsweredAssumed Answered

Making a Table more Efficient

Question asked by jhullinger on Jan 8, 2019
Latest reply on Jan 8, 2019 by badmonkey842

I have a table in my solution, call it JobMaterials. In it as a number of calculation fields; quantity * cost, quantity * weight, return quantity * cost and a few such others. They end up really bogging down the speed for WAN users. Since the fields arent actually needed on 19 out of 20 queries I thoughT a good solution would be to put them in a related table so they are only called on when needed. That worked great until I went to pull summaries back from them. I can't seem to get it to work. In some instances I can use executeSQL but not all because it doesn't take into account the found set. All of my efforts to use GetSummary have failed. The only thing thats worked in some instances it putting the report or layout in the context of the related table. This is problematic though. Can anyone offer some help. I am sure there is an easy solution to this that is just alluding me.

Outcomes