big tables performance
I'm writting an application to store about 250.000.000 rows per month (about 8 million at day) and I need to store 6 months of data.
The application makes the insert and then queries for some data (the table has only 4 integer fields).
My question is, what machine I need? I think I have to build more than one table (one per month) and join together using views or merge engine but I need queries takes no more than 10 seconds.
I'm going to buy some dell hardware with dual Xeon 3.2ghz, 4 Gb ram, 6 scsi disks (10000rpm) using raid 5.
PD: its a network monitoring system
Subject
Views
Written By
Posted
big tables performance
4720
October 21, 2004 11:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.