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

sponsored links
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.
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

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

  • Rails2.0.2 change the default DB adpter

    In Rails2.0.2 rails demo ... ... MissingSourceFile in SayController # hello no such file to load - sqlite3 RAILS_ROOT: / home / kenb / rails-projects / demo ... ... Checked config / database.yml, adpter default is set become the sqlite3. Check the ra ...

  • [Ask] Rest nested resources helper method

    (Novice, studying RestFul_Rails, rails 2.2.2) Nested resource definition is as follows: And in the project under the index view using the following code: Results page error: iterations_path undefined I would like to ask how are going on? The teaching ...

  • A common JavaScript page

    1.JavaScript code 2.CSS code 3. The use of examples

  • Hibernate primary key strategy-sequence

    Today, the use of hibernate in the company encountered a troublesome problem, the use of hibernate when the primary key generation strategy set sequence, but always reported in the implementation could not get next sequence value of the error, then o ...

  • Oracle instant clent for ruby / rails on cygwin

    Environment: XP: oracle full client, ruby, rails, gem cygwin: ruby rails, gem (the version with the XP version) Needs: for cygwin is installed under the rails platform support oci Steps: <1> download oracle instant client ( Instant Client Pa

  • spring + hibernate + oracle9i to read and write CLOB

    Database-driven update classes12-9i.jar Hibernate modify the configuration of the following code <bean/> <bean Lazy-init="true"> <property name="nativeJdbcExtractor"> <ref local="nativejdbcExtractor"/>

  • Hibernate connection pool configuration

    Hibernate connection pool configuration <! - Jdbc -> <property name="connection.driver_class"> oracle.jdbc.driver.OracleDriver </ property> <property name="connection.url"> jdbc: oracle: thin: @

  • can not be represented as java.sql.Timestamp

    Development of procedures for the use of hibernate when, some time there is no need to fill in the fields, but after the hibernate query time reported "Java.sql.SQLException: Value'0000-00-00 'can not be represented as java.sql.Timestamp ...

  • Collection of articles about hibernate

    Read a few times, or have the need to look at Given the recurring discussion of the applicability of the post hibernate, the wish to have a conclusion Reference Posts: OpenSessionInView will not affect the performance? Choose Hibernate or iBatis? Cho ...

blog comments powered by Disqus
Recent Entries
Tag Cloud
Random Entries