File>Database>Information

joe361joe361 Member Posts: 2
edited 2006-12-19 in NAV Tips & Tricks
In Navision 3.01, native database version, if you go to File>Database>Information and click the Tables button there’s a column labeled Optimization. I was wondering what the numbers mean, is a low number better than a high number, what’s the range, etc.

Title changed from "Tables Question" to "File>Database>Information" because it is a better title for Navision Tips&Tricks

Comments

  • krikikriki Member, Moderator Posts: 9,094
    -"No of Records": this is the number of records in the DB.
    -"Record Size": this is the size of 1 record (data + indexes)
    -"Size (KB): this is the total size the table uses (data + indexes)
    -Optimization : the higher the number, the more optimized the table is. This can be both good and bad.
    -If you have a table that you READ a lot and WRITE almost never (e.g. T15:"G/L Account") it is better optimized because an optimized table can be read faster. So this is a table you can optimize.
    -If you have a table that you WRITE a lot (independant of reading) (e.g. T17:"G/L Entry", T37:"Sales Line"), is is better NOT to optimize it, because optimizing speeds up for reading but slows down for writing. In general a table that is not optimized is between 50% and 60%.

    This was for a Navision DB. I suppose you have a Navision DB.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • WaldoWaldo Member Posts: 3,412
    May be you can put this on tips&tricks? Don't think many people know this.
    =D>

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • ara3nara3n Member Posts: 9,255
    -"Record Size": this is the size of 1 record (data + indexes)
    -"Size (KB): this is the total size the table uses (data + indexes)

    I believe it's (data + indexes+sift tables + sift indexes)
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • krikikriki Member, Moderator Posts: 9,094
    ara3n wrote:
    -"Record Size": this is the size of 1 record (data + indexes)
    -"Size (KB): this is the total size the table uses (data + indexes)

    I believe it's (data + indexes+sift tables + sift indexes)
    True. But SIFT-tables are partly data and partly indexes.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • DenSterDenSter Member Posts: 8,304
    Part of the table size though, although I don't know for sure if that is the case on SQL Server, since those are separate physical tables.
  • krikikriki Member, Moderator Posts: 9,094
    [Topic moved from Navision Attain forum to Navision Tips & Tricks forum]

    Title changed from "Tables Question" to "File>Database>Information" because it is a better title for Navision Tips&Tricks
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.