topic table size in Application Development and Automation Discussions

table size

Former Member — Wed, 02 Jul 2008 11:09:52 GMT

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.

Re: table size

valter_oliveira — Wed, 02 Jul 2008 11:11:28 GMT

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.

Re: table size

GauthamV — Wed, 02 Jul 2008 11:12:51 GMT

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

Re: table size

Former Member — Wed, 02 Jul 2008 11:12:58 GMT

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

Re: table size

Former Member — Wed, 02 Jul 2008 11:13:03 GMT

Hi,

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

Thanks,

Sriram Ponna.

Re: table size

Former Member — Wed, 02 Jul 2008 11:15:43 GMT

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

Re: table size

Former Member — Wed, 02 Jul 2008 11:18:41 GMT

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

Re: table size

paruchuri_nagesh — Wed, 02 Jul 2008 11:25:37 GMT

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

Thanks & Regards

Nagesh.Paruchuri

Re: table size

former_member654348 — Wed, 02 Jul 2008 11:39:28 GMT

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.

Re: table size

Former Member — Wed, 02 Jul 2008 13:02:52 GMT

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