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.
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.