Hi All,
 Currently we are preparing the final result row wise, as number of columns
present in project list(80 columns) is high mainly measure column or no
dictionary column there are lots of cpu cache invalidation is happening and
this is resulting to slower the query performance.

*I can think of two solutions for this problem.*
*Solution 1*. Fill column data vertically, currently it is horizontally(It
may not solve all the problem)
*Solution 2*. Use code generation for result preparation.

This is an initially idea.

Kumar Vishal

Reply via email to