Record Size in Dynamics NAV

DynamicsDave · 2016-03-08

With regards to the record size in NAV, is there any way to find out what space is still available in a table in NAV i.e. how much of the 4K/8K(in newer versions) has been used?

I know I can add Dummy Fields until I get the error message when saving the table, but I was wondering if there was a more efficient way of finding this information?

I thought the Record Size field in the Table Information virtual table may have been the value I was looking for but when I filter to Table 37 in this table, there is a different Record Size value for the table in each of the companies in the database, and some of the other tables seem to have a Record Size greater than 8K.

Any pointer would be great.

Thanks in advance,

Dave

RockWithNAV · 2016-03-09

RockWithNAV wrote: »

Hey Bilias,

Yes you are correct because of the Indexes and the Keys and the logic very simple.

Like suppose we have 4 Columns of 20 Byte each in the Table.

Table - C1 - C2 - C3 - C4 - Size - 80 Byte

Now say we have made 4 Keys in this table and the combination is like

1. C1,C2,C3
2. C2,C4
3. C1,C4
4. C2,C3,C4

So now if you calculate it will hit 200 Bytes.

Hope this Helps.

Thanks

Blog - https://rockwithnav.wordpress.com/

RockWithNAV · 2016-03-08

Hey Dave

Refer to this Link

http://forum.mibuso.com/discussion/1362/maximum-number-of-fields-max-record-size

Hope this helps.

Thanks

Blog - https://rockwithnav.wordpress.com/

DynamicsDave · 2016-03-08

Thanks RockWithNAV,

I had found that thread as well, but the only idea I could see mentioned in it was to add up the bytes of each of the individual fields and I was wondering if the record size was actually held somewhere within NAV?

Dave

RockWithNAV · 2016-03-08

Hey Dave,

Record Size must not be greater then 8000 Bytes.

See this screenshot

Thanks

Hope this Helps.

Blog - https://rockwithnav.wordpress.com/

DynamicsDave · 2016-03-08

Thanks RockWithNAV, but what I'm unsure of is there any other way of finding what the record size of the active fields is without trying to save the table & getting this message? I am trying to determine how many more fields I can fit into the Sales Line table without having to add them & then save the table after adding each field to see if it has gone over the 8000 byte limit.

RockWithNAV · 2016-03-08

Hey Dave,

Yes you can, Follow this Step -

1. Make a New Page
2. In the Table name write - Table Information
3. Make it list
4. Press Next and complete the Wizard.
5. Run the Page
6. Filter for your company and Table.

Thanks
Blog - https://rockwithnav.wordpress.com/

RockWithNAV · 2016-03-08

Table Information is a Virtual Table.

DynamicsDave · 2016-03-08

DynamicsDave wrote: »

I thought the Record Size field in the Table Information virtual table may have been the value I was looking for but when I filter to Table 37 in this table, there is a different Record Size value for the table in each of the companies in the database, and some of the other tables seem to have a Record Size greater than 8K.

I tried this but I couldn't understand why the record size was different for different companies in the same database, and why some tables seemed to have a record size greater than 8K.

RockWithNAV · 2016-03-08

Hey Dave

Sorry for the contradiction b/w the understanding. You asked Record size so i felt you are now concerned of the memory its occupying. This Table information shows the

Record Size - Average size of a record.
Size (KB) - Space table Occupies in Database.

As far as the Development environment is concerned i dont think theres any way to calculate how much fields you can more create until and unless you face that error. The point is number of fields always depends on how much of Byte you have available like if a length of 100 Byte is available you can either create 50 byte of two Fields or 10 byte of 10 Fields. You can need calculate this depending upon each fields you have created.

Thanks
Blog - https://rockwithnav.wordpress.com/

Belias · 2016-03-08

"why some tables seemed to have a record size greater than 8K." < because that size includes also the Keys/indexes.
AFAIK, there's not an easy way to do it

RockWithNAV · 2016-03-09

Hey Bilias,

Yes you are correct because of the Indexes and the Keys and the logic very simple.

Like suppose we have 4 Columns of 20 Byte each in the Table.

Table - C1 - C2 - C3 - C4 - Size - 80 Byte

Now say we have made 8 Keys in this table and the combination is like

1. C1,C2,C3
2. C2,C4
3. C1,C4
4. C2,C3,C4

So now if you calculate it will hit 200 Bytes.

Hope this Helps.

Thanks

Blog - https://rockwithnav.wordpress.com/

RockWithNAV · 2016-03-09

RockWithNAV wrote: »

Hey Bilias,

Yes you are correct because of the Indexes and the Keys and the logic very simple.

Like suppose we have 4 Columns of 20 Byte each in the Table.

Table - C1 - C2 - C3 - C4 - Size - 80 Byte

Now say we have made 4 Keys in this table and the combination is like

1. C1,C2,C3
2. C2,C4
3. C1,C4
4. C2,C3,C4

So now if you calculate it will hit 200 Bytes.

Hope this Helps.

Thanks

Blog - https://rockwithnav.wordpress.com/

DynamicsDave · 2016-03-09

Thanks for the help guys. That makes sense - guess I'll have to go with creating dummy fields to identify how much space is left.

Thanks again,

Dave

Record Size in Dynamics NAV

Best Answer

Answers

Categories