QA isn't as much of a problem - it'll work ok, but how fast will it run when full?

My problem is not knowing how much data Firebird can handle, and getting procedure results back in under 1/10th of a second.

If anyone's has experience with MASSIVE databases, they'd know a winning schema if they saw it.

it's here anyway:
http://ecr.sf.net/partsnet.tgz

Sorry if this entirely the wrong list - I thought the spreading use of Firebird throughout more business sectors would be in everyone's business.

What is a good mailing list to post schema's for review?...it's be interesting reading.

Nigel



On Tue, 15 Oct 2002 10:28:31 +0100
"Jason Chapman (JAC2)" <jason@...> wrote:

> mmm, I think this should be in the support group and also I guess if your
> getting paid for it, whoever is going to QA it for you might also want to
> get paid for it as well.
>
> Jason Chapman
> JAC2 Consultancy
>
> Training - Development - Consultancy
> Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
> Troubleshooting projects, QA.....
> www: When I get round to it....
> Mob: (+44) 07966 211 959 (preferred)
> Tel: (+44) 01928 751088
>
>
> "Nigel Weeks" <nweeks@...> wrote in message
> news:20021015154453.5ccdb80f.nweeks@......
> > I'm planning on building a rather large database to cater for a few parts
> suppliers in my area, running solely on Firebird.
> >
> > I've tested it with reasonably big recordsets(13 million rows), but
> nothing this big.
> >
> > It could be handling multiple millions of parts, from wrecking yards and
> car bodies, to washing machines and pump seals.
> >
> > Is there anyone on this list I could email the schema to, have a browse,
> and give any feedback to me?
> >
> > Main issues
> > Speed(this must really fly)
> > Normalisation(is this the 'most right' way of doing it)
> >
> > The code is fairly well commented.
> >
> > Anyone willing?
> >
> > Nigel
> >
> > Community email addresses:
> > Post message: IBDI@yahoogroups.com
> > Subscribe: IBDI-subscribe@yahoogroups.com
> > Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> > List owner: IBDI-owner@yahoogroups.com
> >
> > Shortcut URL to this page:
> > http://www.yahoogroups.com/community/IBDI
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
> Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>