Re: Database performance and size

markp10013_at_aol.com (MarkP10013) wrote:

>I was wondering if someone could shed some light on this debate;
>Some people I've talked with think that the performance of a database will
>be
>affected as the number of rows in the tables grow. Others say that
>performance
>won't be affected at all no matter how large the database gets. Which
>opinion is true? I know this sounds trivial, but it's seem to be one of
>those questions that tests theory and real world experiences.
 

> regards,
 

> Mark

It depends upon your end application, I think. If your application crunches rows and rows forming aggregations for a warehouse scenario then the features in 7.2 and (7.3) will provide good levels of performance based upon the single 'worker' thread spawning multiple threads via parallel query. If its OLTP then the previous index posts come to the fore. Regardless of algorithm you system wll only perform to the the level of database design, implementation and hardware 'grunt' that you can apply. A 3Mill row full table scan with PQ on 2 cpus with union aggregation across (for example) partitioned unit sales tables, will not come close to the same process on 16 cpus

. Received on Fri Dec 22 1995 - 00:00:00 CET