Home » RDBMS Server » Server Administration » System slowdown: due to large number of records???
System slowdown: due to large number of records??? [message #53425] Thu, 19 September 2002 01:29 Go to next message
kim
Messages: 116
Registered: December 2001
Senior Member
Help! We have a system that generates a daily report. At first, this report usually takes about a half hour to generate. However, after about 3 months of using the system, we have experienced a system slowdown and this has been traced to the generation of the said report. Does the number of records of the table that this report makes use of have anything to do with the slowdown? The table already has 5,000,000+ records now. Original space allocation for this table is 1.3 GB, but only 209 MB is left now. What should we do? Will it help if we allocate more space for this table? Any suggestions would be greatly appreciated. Thanks!

Report message to a moderator

Re: System slowdown: due to large number of records??? [message #53427 is a reply to message #53425] Thu, 19 September 2002 03:43 Go to previous messageGo to next message
satish
Messages: 112
Registered: September 2000
Senior Member
Hi,

Export and Import the table.
analyze statment on the mentioned table.

Regards,
Satish.

Report message to a moderator

Re: System slowdown: due to large number of records??? [message #53435 is a reply to message #53425] Thu, 19 September 2002 09:56 Go to previous messageGo to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Why do you wanna export and import the table ??

Analyze is a good idea. Any structure change in the table or just more data ?

Thought of partiotions ??

Report message to a moderator

Re: System slowdown: due to large number of records??? [message #53477 is a reply to message #53425] Mon, 23 September 2002 12:00 Go to previous message
Gilson Sirvas
Messages: 6
Registered: September 2002
Junior Member
Hi.

If your table has a lot of daily transactions, you should rebuild your indexes, beside that you ought make an explain plan of the statements used in your reports procedure to see how the statements are being processed

Regards
Gilson

Report message to a moderator

Previous Topic: Database creation : Creating exact copy of database
Next Topic: How to save a Table permanantly?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:05:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.