2 Replies Latest reply: Nov 7, 2012 5:05 AM by sabre150 RSS

    slow wage calculation

    972872
      Hi.
      I have an ERP, developed on Spring, Struts 1, Hibernate, JSP and deployed on tomcat.My database is Oracle 11.
      I have module for wage caculation that shoul calculate wage for 3000 staff.

      for the first staff calculation madule spend about 5 seconds but for the 1000th staff this time is about 70 seconds and increase staff by staff to 5 min.
      Why?
      What can I do?
      Please help me.
        • 1. Re: slow wage calculation
          EJP
          I have module for wage caculation that shoul calculate wage for 3000 staff.

          for the first staff calculation madule spend about 5 seconds but for the 1000th staff this time is about 70 seconds and increase staff by staff to 5 min.
          Why?
          All of those numbers are orders of magnitude too high, starting with the 5 seconds, and the time should be constant per row. You must be doing something wrong, and your database must also negate this indexes that your queries and updates require.
          • 2. Re: slow wage calculation
            sabre150
            Cross posted - http://www.coderanch.com/t/597116/Performance/java/slow-wage-calculation