Re: Oracle 8i Database with 18,000 Partitions

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 12 Nov 2002 22:49:39 -0000
Message-ID: <3dd18d36_1@mk-nntp-1.news.uk.worldonline.com>

"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3dd103f8$0$12763$afc38c87_at_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

And maybe (almost, but not quite, the same question):

Regardless of RDMBS, has this vendor successfully implemented this design in ANY other site?

Just a thought.

Paul Received on Tue Nov 12 2002 - 16:49:39 CST