Re: Oracle 8i Database with 18,000 Partitions

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 13 Nov 2002 00:25:44 +1100
Message-ID: <3dd103f8$0$12763$afc38c87@news.optusnet.com.au>

11 Nov 2002 09:55:01 -0800, Tom Glover said (and I quote):
>
> I have a third party vendor who is pushing a customer database design
> that will contain over 15,000 partitions. Basically, each customer
> will have a partition with approximately 30,000 - 50,000 records. The
> partitions can be restored on a very regular basis (100 - 200
> customers per day possible). So, I have a few questions as to the
> feasibility of this design:

I have only one, maybe two questions myself:

1- Has this vendor successfully implemented this design in ANY other RDBMS? 2- If yes, I'd love to know which and see proof of it. If not, the next question is: WTF are they trying to stuff up the client?

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam

Received on Tue Nov 12 2002 - 07:25:44 CST