Configuring advanced tab in database properties

zaurb
zaurb Member Posts: 26
edited 2009-11-09 in NAV/Navision Classic Client
Hi!

I have transfered our 3.70 database to a new 2008 server with Dynamics NAV 5.0 SP1 backup/restore. When creating a database in a new environment there's a new tab 'Advanced', which has several options in it. What is the best practice to configure this options?
Zaur Bahramov

Comments

  • DenSter
    DenSter Member Posts: 8,307
    While in that screen, hit F1. There is an explanation in there for every setting. Let us know if you have any specific questions about any of them.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • zaurb
    zaurb Member Posts: 26
    I'm interested in setting 'Caching Row set'. As for caching row set, the default value is 500. Why would we have to change it?
    The Help says:
    If a FINDSET statement reads more than the number of records specified here, additional SQL statements will be sent to the server and this will degrade performance. Increasing this value will also increase the amount of memory that the client uses to support each FINDSET statement.

    What is it about? Should we do some modifications to this value?
    Zaur Bahramov
  • DenSter
    DenSter Member Posts: 8,307
    This has been discussed in the SQL forum many times before. Click on the "Search the forum" link and see if you can find some of those articles.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories