Configuring advanced tab in database properties

zaurb

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?

DenSter

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.

zaurb

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?

DenSter

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.