table size

[Former Member]

Hi Experts !

i have created a table in which size category is 3 and record can be upto 26,000 . plz tell me what happen if records reached to 26001. how i can tak care .

thanks.

[valter_oliveira]

Hello.

The table won't blow up, or something similar! That indicator refers to memory alocated in database. If you choose 20000 records, it will alocate space to 20000. If you have 20001, you will alocate memory for more 20000. Only performance issue.

Regards.

Valter Oliveira.

[GauthamV]

hi,

the size category defines specific memory allocations in database,so if the records r exceeded by 26,000 also it will store but may be the stored at different place.

Edited by: gautham chakraverthi on Jul 2, 2008 7:13 AM

[Former Member]

Hi Ranjna,

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.

Best regards,

raam

[Former Member]

Hi,

Nothing to worry, system will take care, but performance wise it may slow.

Thanks,

Sriram Ponna.

[Former Member]

nothing will happen... when the allocated spzce is filled up the system will automatically create sapce for another 26000 records.

[Former Member]

Hi,

Nothig to worry. This table size is defined to allocate the memory on the initial bases. If ur record will exceed the prescribed limit then system will allocate more memory. No Record will be missed.

Regards

Sumit Agarwal

[paruchuri_nagesh]

Hi

nothing will happen system will reallocate memory but it decrease performance so, be generous while defining size category

Thanks & Regards

Nagesh.Paruchuri

[former_member654348]

Hi,

Whenever you are specifying a size category, it is the intial size.

That means for your table initial memory size is 26000records. If more records are coming the sytem automatially creates some more place and adds the records.

But if your table is a smal table and it may have only 100 records even in future for example, but u made a size category such that it can store 26000 records, then it is a performance issue because, unnecessarily memory is getting wasted.

[Former Member]

HI,

Whenever you create a table initially 8 kb memory is allocated. once this memory is full the memory specified by you is allocated to the table. If this is full another slot of memory with same size is allocated.

so there will be no issue when you create another record

regards

padma