topic Re: Table issue...? in Application Development and Automation Discussions

Table issue...?

Former Member — Wed, 19 Dec 2007 13:07:10 GMT

As all of you know like while creating the table will choose the size from 0 – 4, assume that I’m chosen Number 1 and restricted records to store till 50,000, now I’m trying to store 50,001 record, what will happens?

Akshitha.

Re: Table issue...?

Former Member — Wed, 19 Dec 2007 13:14:16 GMT

Hi,

If you have specified a size category of 0 ( say records 0 to 15000) and if your number of records are exceeding then the above said limit then a new memory area would be allocated to your table memory .

But doing this is not suggested as it causes the performance problems. If you know at at any given point of time your table may contain more than the limit you are giving then in that case you should always go for the higher limit.

Please see the F1 help for size category :

The size category determines the probable space requirement for a table in the database.

You can select the categories 0 to 4 for your table. Each category is assigned a specific fixed storage area value in the database. When you create a table, initial space is saved for it in the database. If more space is required later as a result of data that has been entered, the storage space is increased in accordance with the category selected.

Press F4 on the field Size category to see the number of data records that can be maintained for the individual categories of your table without complications ensuing. These complications could be for example a reorganization becoming necessary because the maximum space to be reserved for the table was exceeded due to the maintained size category.

Hope this would be helpful to you.

Thanks,

Lalit

Re: Table issue...?

Former Member — Wed, 19 Dec 2007 13:14:46 GMT

The record will still be stored in the table but the performance will suffer. When you create the table the database will 'reserve' space for the size categorie you have choosen and if you exceed that number of records the database has to grab more space which will affect the performance negatively the more you exceed that number.

Michael

Re: Table issue...?

Former Member — Wed, 19 Dec 2007 13:21:24 GMT

Hi,

Nothing will happen, it will consider all the records. It is mainly deals with memory. It actually retrieves the data on based on memory paging.

Thanks,

Sriram Ponna.

Re: Table issue...?

Former Member — Wed, 19 Dec 2007 13:50:51 GMT

Hi,

When you are inserting records more than the number of records you initially allocated thru size category system stores extra records in paging memory not in main memory.so it will take more time compared to main memory.

so you just discuss with functional consultant what should be the estimate no of records in production and allocate like that.

so you will not get any error but access time is more.

Regds

sivaparvathi

Please reward points if helpful....

Re: Table issue...?

Former Member — Wed, 19 Dec 2007 13:53:33 GMT

good

you can add the new record to the table but i dont think it ll update the same in the particular table field.

thanks

mrutyun^