Hi all, I have a question about the database size, when i add an (empty) field to a table, where or what space is reserved for it? When i do so, i don’t see the database size increase anywhere… Can anyone tell me if there is any documentation about this or maybe know where this space is reserved? Thanks for your time, Kind regards, Robin van den Boom
Hello Robin, How many records do you have in the table you are adding the new field to? If you are adding the field to a table with only a few hundred records, then you may not notice a difference. If you are adding to the Cust. Ledger Entry or G/L Entry table, then you will probably see a significant increase in the database size. When you do this, the database will “use” the space, even though there is no data in the fields. You need to be careful that there is plenty of space free in your database when expanding tables with a large number of records. One customer I used to look after imported some expanded tables into a full database and created a database corruption, which we had to fix. -------------------------------- Edward Bloomfield Navision Support Consultant Cambridge Online Systems Limited www.cambridgeonline.net
It is my understanding that the Navision data base does not allocate space for data that is not present, i.e. “empty” fields take almost no database space. But there is a field identifier code and data length code for each data field, whether filled or empty. So the amount of space taken by an empty field would be small but tangible and greater than zero. Someone else may be able to expand on this (or of course correct me if I’m wrong). Dave Studebaker das@libertyforever.com Liberty Grove Software A Navision Services Partner Edited by - daves on 2002 May 22 16:17:49
Hi, I read somewhere that system does not allocate space for empty Text and Code fields. That’s why Navision clear Description field in the Item Ledger Entry table if description the same as Item Description. Valentin Gvozdev Andel Jewelry Inc.