Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    69

    Unanswered: Performance Issue

    Hi
    we are currently using db2 6.1. We have a huge reports which right now we are storing it in a single table. The contents of the reports are also very huge and since we are storing it in a space of varchar2(4000) we are seeing multiple inserts.
    So this makes as messy in the production as we are facing some problems generating this huge chunk of data. What's the efficient way we can eliminate. Is there any normalization we can do?. Give me some suggestions.
    thankx

  2. #2
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    Can you eloborate . What kind of performance are you looking for.
    Space , Locks or what !!!

  3. #3
    Join Date
    Mar 2003
    Posts
    69
    Ok. Let me eloborate in detail. We are running a Hiring Application System. So normally the applicant comes and input's his data in to our system. So we have weekly, daily and monthly reports which stores the kind of reports like the total applicants hit the system, the completed applicant's the summary etc. This all the reports we are storing in a "report" table in a field called "reppot_desc". This can have varchar2(4000). Actually the reports are generated by a component and we are storing the generated html in to this element. Means some 40 to 50 kb html file in a field that can hold 4000 characters. So when the number of records increases, we are facing some problem like the reports are not generating properly etc. What is the efficient way. Note that we are generating reports based on our regions groups and the districts.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •