Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!border1.nntp.sjc.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsmm00.sul.t-online.de!t-online.de!news.t-online.com!not-for-mail
From: "Markus Vohburger" <markus.vohburger@t-online.de>
Newsgroups: comp.databases.oracle.server
Subject: Info on large tables wanted
Date: Sun, 6 Jun 2004 22:27:21 +0200
Organization: T-Online
Lines: 60
Message-ID: <c9vumj$3e9$05$1@news.t-online.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: news.t-online.com 1086553619 05 3529 bLj+GbvOX1evSHI5 040606 20:26:59
X-Complaints-To: usenet-abuse@t-online.de
X-ID: SSNt7TZSZe1AUd2CeiwSxWOxGG71FdW-BDv1RNOXK0XcUUIANBG+sE
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Xref: core-easynews comp.databases.oracle.server:222279
X-Received-Date: Sun, 06 Jun 2004 13:27:32 MST (news.easynews.com)

Hello out there!


I am just planning a new Reporting Application for a large chain of
bakeries. I have done already applications like this, but not with that
amount of Data.


Roughly, the Bakery has 120 Shops.
Each Bakery has about 500 Customers per Day
Each customer buys 2 Different Items in Average. There are about 100
different Items.

so this makes
120*500*2 = 120000 Items bought per day
120000*6 =  720000 per week
720000*50 =36.000.000 per Year with 300 buisness days

Raw data is delivered in the following Format

Shop-ID Integer
Item-Id Integer
Item Amount Float
Item Price Float
Timestamp DateTime


I need to build a database where each Item is stored with the above Data, so
they can make Reports on when particular Items sell best eg.

Is there a problem with tables that contain 36.000.000 records? maybe they
want to accumulate 5 Year of Sales Data, so this would make over 150.000.000
records.

I have done several tests with about 10.000.000 Dummy Records on my test
machine.
AMD2000, 1GB Ram, Index Tablespace on a seperate harddisk and the like, the
response time was quite satisfactory, but will it be with 20 times the data?

Has anybody experience with such large Tables?
How big are your Databases (number of Records)
What machines do you use?

Any comments welcome!

regards
MV