topic Bespoke table technical details in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/bespoke-table-technical-details/m-p/8453273#M1649722 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>SAP system 470</P><P></P><P>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 ....</P><P></P><P>I have two questions</P><P></P><P>1. I want to increase the table size to 600,000 to 24,000,000,, will this cause any problems?</P><P>2. when reading the table currently with table size (300,000 to 600,000) with 900,000, will this cause system performance issues? </P><P></P><P>Currently there is no table buffering ....</P><P></P><P>The table is updated and read frequently.</P><P></P><P>Any suggestions would be appreciated</P><P></P><P>Regards</P><P>J-J</P></BODY></HTML> Thu, 12 Jan 2012 11:00:34 GMT TJRP 2012-01-12T11:00:34Z Bespoke table technical details https://community.sap.com/t5/application-development-and-automation-discussions/bespoke-table-technical-details/m-p/8453273#M1649722 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>SAP system 470</P><P></P><P>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 ....</P><P></P><P>I have two questions</P><P></P><P>1. I want to increase the table size to 600,000 to 24,000,000,, will this cause any problems?</P><P>2. when reading the table currently with table size (300,000 to 600,000) with 900,000, will this cause system performance issues? </P><P></P><P>Currently there is no table buffering ....</P><P></P><P>The table is updated and read frequently.</P><P></P><P>Any suggestions would be appreciated</P><P></P><P>Regards</P><P>J-J</P></BODY></HTML> Thu, 12 Jan 2012 11:00:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bespoke-table-technical-details/m-p/8453273#M1649722 TJRP 2012-01-12T11:00:34Z Re: Bespoke table technical details https://community.sap.com/t5/application-development-and-automation-discussions/bespoke-table-technical-details/m-p/8453274#M1649723 <HTML><HEAD></HEAD><BODY><P>Hi J-J,</P><P></P><P>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.</P><P></P><P>You can increase it to the next level without any issue.</P><P></P><P>Regards,</P><P>Marcin</P></BODY></HTML> Thu, 12 Jan 2012 11:54:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bespoke-table-technical-details/m-p/8453274#M1649723 marcin_milczynski 2012-01-12T11:54:27Z