Bespoke table technical details

[TJRP]

Hello,

SAP system 470

I have created a bespoke table and set the size category to be 5 (300,000 to 600,000). Currently the table has just under 900,000 records and it's only going to get bigger ....

I have two questions

1. I want to increase the table size to 600,000 to 24,000,000,, will this cause any problems?

2. when reading the table currently with table size (300,000 to 600,000) with 900,000, will this cause system performance issues?

Currently there is no table buffering ....

The table is updated and read frequently.

Any suggestions would be appreciated

Regards

J-J

[TJRP]

Hello,

SAP system 470

I have created a bespoke table and set the size category to be 5 (300,000 to 600,000). Currently the table has just under 900,000 records and it's only going to get bigger ....

I have two questions

1. I want to increase the table size to 600,000 to 24,000,000,, will this cause any problems?

2. when reading the table currently with table size (300,000 to 600,000) with 900,000, will this cause system performance issues?

Currently there is no table buffering ....

The table is updated and read frequently.

Any suggestions would be appreciated

Regards

J-J

[marcin_milczynski]

Hi J-J,

The table size category is set just for information purpose for the DB to reserve space for the table in order to avoid fragmentation of data. This settings was espacially for DB 10 years ago, but now the DB Management Systems usually handle the table allocation automaticalyl based on the actual table size and number of read/write operations executed on the table.

You can increase it to the next level without any issue.

Regards,

Marcin