The company first entered the company I would like to Optimize SQL project

I was a time not long into the company of people, but also a person to be graduated, but immediately entered the project team, involved in the development.

The project is to make a China Telecom Operation System, is a big system. My so-called development, is again patchy, in the repair process I discovered that many features of this project, code rate, so very complicated. Recent customer response system is always very slow, after my tests found that the system is really very slow, if the workers are single query, or workers are single statistics, select the date, if large span, the query time was required to reach 10 minutes as long as customers are unable to tolerate the Can not Wait for all time. Later, as I have looked carefully and constantly to ask people came to the conclusion that a preliminary conclusion is that the efficiency of Writing sql statement is not high, there may be necessary to optimize oracle database.

As a novice, I now have an impulse to want to optimize the whole system sql statement, to improve efficiency. But now my technology is limited, I hope that you recommend some information so that I can study study, and have the ability to achieve after this my mind.

Thank you everyone.

分类:Development 时间:2009-02-28 人气:1620
blog comments powered by Disqus


iOS 开发

Android 开发

Python 开发



PHP 开发

Ruby 开发






Javascript 开发

.NET 开发



Copyright (C), All Rights Reserved. 版权所有 闽ICP备15018612号

processed in 0.071 (s). 12 q(s)