2008 Nov 05 10:42 AM
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.
2008 Nov 05 10:49 AM
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.
2008 Nov 05 10:45 AM
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
2008 Nov 05 10:49 AM
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
2008 Nov 05 10:59 AM
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@
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |