Home » RDBMS Server » Performance Tuning » Optimization for Large-Volume Data Streams (Oracle 8i,Windows 2000)
Optimization for Large-Volume Data Streams [message #301658] Thu, 21 February 2008 04:44 Go to next message
ramsatish
Messages: 8
Registered: November 2006
Junior Member
Hi,
I have 25 tables in my oracle database, which consists of 50,000 records each on an average.
Those tables get refreshed everyday(previous day's data will get deleted and current date's data get inserted).
There is a requirement to generate multiple reports for all the accounts having the same format. Those reports are based on
last seven days data, hence require to store data for last week.
My idea is to create a single table which stores all the data of 25 accounts for last 7 days.It means that table consists of
25(accounts)*7(days)*50,000(Number of records in each account)=87,50,000 records.
I implemented my plan taking 3 accounts and for 3 days data.It means that table consists of
3(accounts)*3(days)*50,000(Number of records in each account)=4,50,000 records.
My observation was, for any simple query on the table is taking a lot of time.
What is the best or optimised way to access larger volume of data in lesser amount of time?

My SYSTEM CONFIGURATION IS:
o/S : wINDOWS 2000
DATABASE: ORACLE 8i
RAM : 2 GB
HARDDISK: 120 GB
PROCESSOR: PENTIUM

Thanks in Advance
Regards,
Sriram Satish
Re: Optimization for Large-Volume Data Streams [message #301661 is a reply to message #301658] Thu, 21 February 2008 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
My observation was, for any simple query on the table is taking a lot of time.

I don't how you do it but it should take not so much time.
Post what you tried and your timing.

Regards
Michel
Re: Optimization for Large-Volume Data Streams [message #301681 is a reply to message #301658] Thu, 21 February 2008 05:58 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Did you considered using partitions ( 25 * 7 partitions)?

Michael
Previous Topic: I cant understand this behavior
Next Topic: Whey sometimes using Exists Function is better
Goto Forum:
  


Current Time: Sun Dec 11 04:24:49 CST 2016

Total time taken to generate the page: 0.11692 seconds