Reducing the Views

I must admit that during the development time of my system I have been abusing our server to take full control on the handling of data leaving the client computers quite spoiled with their processor though the network bandwidth felt the pressure of traffic as I throw all the major transaction on their main highway. Having 1Gbps bandwidth in our switch and a dual processor in our Intel Xeon server makes me put those entire machines to their limits. I just can't believe that a file base single task database in a 2.6a FoxPro database perform so smooth in an environment like this. Which leads me to a simple question what about a database server that is created for multi-tasking? It did perform very well during the test run all my frustration and fears was quite solve but not after a rigorous analysis and observation of the performance in Sql Server 2000 plus redesigning the database table and Visual Basic codes.

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.

Photobucket - Video and Image Hosting

Guess what? I'm a happy geek! more work to go...

Comments

Anonymous said…
Hey maks, let me guess your using SQL Server 2000 Personal Edition? am i right? Anyways, why not use T-SQL its much faster.
12:48 PM
Anonymous said…
redesign ur system dude. 4,000 views and counting eh? 4GB of RAM cannot keep up with that much. Been running SQL Server with moderate tables, views, stored proc and it's taking up 200MB of mem plus 700MB of virtual mem... tweak also ur sql serv to maximize mem use. i rememeber you have to put something in boot.ini, a switch, if you have 1.5GB of ram or more to maximize the efficiency of sql srvr(or i think its exchange hmmm)...
1:28 AM
maks said…
Hi Jane hehehehe I guess you should try it one of this day's :D

Nope im using SQL Server 2000 Enterprise Edition. Thenks for the help I will check on T-SQL.

Our current server has a 2GB of ram and it's doing great. Some modules are being used for almost 6 months now. So far so good. Don't worry ill take note on those things you said to me and look for an answer
7:44 AM
Anonymous said…
I didn't understand the whole scenario completely, but I am glad you found a way to solve the dilemma. I'm still massaging my head due to a minor headache your post caused me understanding about views,servers and all. My, I am ashamed having described my blog "computers, gadgets, etc" when I can't even understand those database-programming stuff. Silly me [waaaahhhhhh!]
4:06 PM
maks said…
hahaha don't be dens we all have our own personal strengths the only difference lang is I just spend more time in database problem thats why Im as weird as this but hey you have a very good skills in giving out point of views and a very informative blog. It really depends on what you really love the most.
8:32 PM
maks said…
Reading again may own post makes me realize that I was very much assuming that my audience have been with me all the time since I started my project. Ok the next time I post something related to this I will do my best to be as detailed as possible in order for you guys to understand. I will do my best.
8:37 PM
Post a Comment

Popular posts from this blog

Apple's Edge Over Microsoft?

In the world of IT, models created by business empires will dictate the future of their products. Microsoft is using the component model as the key to win customers and Apple is using the end-to-end model. Microsoft Windows platform crushed Apple's Macintosh platform the day Microsoft release Windows 98 and pirates come out in the open and dominate every stall in our local mall and computer shops. iPod maybe the best and coolest mp3 player that I have ever seen but I still don't think that Apple will dominate the cell phone era for this place belongs to Asia particularly Nokia and Sony Ericson. I don't know why Walter Mossberg thinks US company will always dominate the world when in fact there is another company that belongs to the world and its called Open Source. I think he is dead wrong with his perception. Without a doubt nobody comes close to iPod in the field of mp3 player however, with the release of Sony Ericson latest cell phone such as W900i. An intelligent human
Read more

High Grounds Cafe - Best Internet Cafe in the Philippines

Image
I was looking for a nice place to chill last Monday to unwind my thoughts and enjoy with my family. I heard about the latest Internet Cafe just open 3 months ago and I decided to check it out. I have seen a lot of Internet Cafe but nothing comes close to this shop. Everything was simply high end from its ambiance, food and computers. It was simply the best place for people who want to collaborate and enjoy together.
Read more

John Gokongwei Speech before Ateneo 2004 Graduates

I wish I were one of you today, instead of a 77-year-old man, giving a speech you will probably forget when you wake up from your hangover tomorrow. You may be surprised I feel this way. Many of you are feeling fearful and apprehensive about your future. You are thinking that, perhaps, your Ateneo diploma will not mean a whole lot in the future in a country with too many problems. And you are probably right. You are thinking that our country is slipping-no, sliding. Again, you may be right. Twenty years ago, we were at par with countries like Thailand,Malaysia, and Singapore. Today, we are left way behind. You know the facts. Twenty years ago, the per capita income of the Filipino was 1,000 US dollars. Today, it's 1,100 dollars. That's a growth of only ten percent in twenty years.
Read more