Hi Pete,

We have decided to perform it in that way (our original data base schema)
in order to test it.
I hope you were right.

Is there any workbench tool kit to check the query time ?

thanks !
german


At 23:10 3/5/2003 +0100, you wrote:

>In message <3E666B98.5060300@...>, Lester Caine
><lester@...> writes
> >German Terrazas wrote:
> >> 10,000 details by 1000 masters = 10,000,000 records in only one
> >> table.
> >
> >So - Whats the problem?
> >
> >Add 10,000 per detail and there is still not a problem.
> >
> >One of my customers ADDS 4 to 5 hundred orders per day with
> >an average of 10 line items per order. 2 million records per
> >year, and now has three years worth. No problem with speed.
>
>And we have a table with 17,000,000 records, and no speed problems there
>either... now that I have set it up it correctly - with the aid of this
>group!
>
>--
>Pete Clark
>
>NO TO WAR
>No more terrorism - Arabic, American, or British
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/