Ansicht
Dokumentation
01817 - Database Size affecting Performance
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up rdisp/max_wprun_time - Maximum work process run timeThis documentation is copyright by SAP AG.
Database Size affecting Performance
SAPers,I have a (hopefully) simple and generic question for the group. As database
size grows on DB2/400, will performance degrade?
For example, with an SAP database grows from 150GB to 300GB over two years,
will this correlate into degraded performance? If a table grows from 20MB
to 20GB will it take longer on reads, writes, and deletes? Will more
memory/CPU cycles be used for the index search?
If not, this tells me that a 10GB system will perform the same as a 10TB
system (all other machine specs being equal) and the only difference is that
one system houses a lot more disk. However, my belief is the opposite, that
DB size does affect system performance. That simply having larger tables
will lead to longer reads, inserts, changes, and deletes. But that's just
my opinion, I could be wrong...What's your opinion?
Thanks in advance,
Mike D. Martin
SAP Basis Administrator
SOLA Optical, USA
707-763-9911 x6106
mmartinZs...
[Non-text portions of this message have been removed]
Durban Tours - Südafrika Safari
rdisp/max_wprun_time - Maximum work process run time Vendor Master (General Section)
This documentation is copyright by SAP AG.
Length: 1599 Date: 20240603 Time: 073747 sap01-206 ( 3 ms )