This discussion is archived
2 Replies Latest reply: Nov 7, 2012 3:05 AM by sabre150 RSS

slow wage calculation

972872 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    Cross posted - http://www.coderanch.com/t/597116/Performance/java/slow-wage-calculation

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points