Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

regarding size category

Former Member
0 Likes
595

i have created a custom table with size category as 0 to....

as it aceepts only 19000 records.when i need to add 25000 record will it accept.if not,what error will be passed.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
570

hi

size cataogiry just allocate space in database to store that table data; if the table records exceed than size catagory limits then those rows are stored in data base but not in sequence because of that performance has slite effect but u need not to consider about that. till the size cataogiry range the records will entered line by line in data base , so when retriving data simple to retrive.

with regds:

rajesh.k

i have created a custom table with size category as 0 to....

as it aceepts only 19000 records.when i need to add 25000 record will it accept.if not,what error will be passed.

3 REPLIES 3
Read only

ThomasZloch
Active Contributor
0 Likes
570

Yes it will accept it. This setting affects technical handling of the table on the database (block sizes, extensions...).

The setting should somewhat reflect the expected number of rows, in your case there should not be a problem. Of course you could also choose the next higher category, no harm in that, afaik.

Thomas

Read only

Former Member
0 Likes
571

hi

size cataogiry just allocate space in database to store that table data; if the table records exceed than size catagory limits then those rows are stored in data base but not in sequence because of that performance has slite effect but u need not to consider about that. till the size cataogiry range the records will entered line by line in data base , so when retriving data simple to retrive.

with regds:

rajesh.k

Read only

Former Member
0 Likes
570

Hi Pranu,

Size category it just determine the amount of space requireed for a table in the database. As you can see when you click on F4 help button of size category 4 categories where each category is assigned a specific fixed storage area value in the database.

Cheers!!

VEnk@