I'm seeing about 20M facts/day input into the system I work on (and we've been going for a few years now) and our average response time is pretty snappy (<15s for the most common use cases).
IIRC, the online part of the database is ~2.5-3TB right now.
-Mark
On Fri, 2008-10-03 at 00:28 +0200, Jasmin Dizdarevic wrote: > Hi, > > i'm actually evaluating different dbms for data warehouse tasks. > has anybody expirience with it? > > i have to store 50 mio. records p.m. in a fact table. > something like this: > > date; cust; group; product; value > > ...with unique index on date,cust,group,product. > > will there be any problem's in response time in let's say 12 months? > > thank you very much. >
-- Mit freundlichen Grüßen
Dizdarevic Jasmin Sonnenbergstr. 3 6714 Nüziders, AUT