Reducing the Views
At the second week of May I have fears that I would add up another 4,000 views just to execute one report. Imagining the number of task I have add up I began to look things ahead of me and finally come up with a conclusion that it will took me another 2 months just to make those views. Not that they where difficult but rather due to the number of views that must be combine and build everything will be bloated. As I internalize about the situation I have realize that I was very much abusive and dependent on SQL Views that I almost forgot the power of the programming language to solve certain scenario. Then on the next day as I execute and use the programming language it only took me half day to get the job done as compared to the views that I have coding over and over again. It did reach the peak of 6,456 before I came into my senses that hey I’m using kindergarten moves.
In summary, just imagine the comparison if I proceed with the views it would take me another 2 months to complete the report while when I use the programming language it only took me half day. Thank God! Here is the shot after I trim the unnecessary views.
Guess what? I'm a happy geek! more work to go...