Alternate for Number Conversions instead of mutiple if Conditions & Challenges in optimizing the App...?
Optimization for my application become a big challenge for me, application size is around 3GB , and Application is very slow for Clicks.
App Details :
1.using String Comparisons
2. some aggregation function
3. many " if " statements for Number Conversion like K , M & B .
4. using Count(Distinct( )) in many Charts and Objects.
What are the Best Possible Optimization techniques we can implement to replace the Above Costly and memory taking functions...?
and also please Send the Different Settings used to be Done in Server and QEMC to get the Better Performance..
and also as a part of optimization technique we tried to move the major calculation into back end ( Script part) but faced few more challenges ( may be we Don't know the Exact procedure for Moving the Major Calculations into the Script ) , Please Send the Best Way to Move the Calculations to the Script part..?
Re: Alternate for Number Conversions instead of mutiple if Conditions & Challenges in optimizing the App...?
There are many aspects which are performance-relevant and which could be optimized. First of all - do you need really all fields and all time-periods/categories ... in your datamodel? Further you should avoid high cardinality fields and combined key-fields (use autonumber instead) and build a proper datamodel and try to categorize and/or flag those fields which are be used in calculations. See here a few links as a starting point for many others here within the community: