Code and Query Optimization

-Optimization for sql query "GetComponentList"
-Optimization for code - calling db functions using transaction
-Output view improved for Sniffing relation