[58352] in SAPr3-news
Re: SAP Performance
daemon@ATHENA.MIT.EDU (Wulf Kruempelmann)
Sat Oct 28 10:01:55 2006
To: sapr3-news@MIT.EDU
Date: Sat, 28 Oct 2006 16:00:29 +0200
From: Wulf Kruempelmann <wulfk@t-online.de>
Message-ID: <ehvnpp$drf$01$1@news.t-online.com>
david.everest@gmail.com schrieb:
> do extra tables affect performance?
>
> the client has 400 tables in use and 60 empty tables with zero
> activity...will this affect the speed of queries, posts, etc?
Hi
a normal R/3 system has roughly 40000 tables (o.k., a 2.1 System has
less than 3000). And 90 % are not used.
They only take some place (but not much) in the database, and therefore
an effect of less than 0.1 % in the performance of the system.
(indices to table structures stored in the data dictionary, etc.)
regards
Wulf
>
> thanks
>
