Set up the DBMS Cache in Attain 3.6 (How?)

Wayne

How can we set up the DBMS Cache on the server. Is there anything we have to take care for. Attain 3.6.
Thanks for feedback. :?:

uo22a1

Use Microsoft MMC, add a Navision snap-in, and you can set the DBMS cache for Navision server.

Waldo

I prefer to use the DOS-utility "server.exe" in the "Database server"-path.

you can type for instance:

>server cache=65000
>server servername=NavisionDBServer
>server database=d:\database.fdb
>server commitcache=yes
>server installasservice
or
>server servername=NavisionDBServer, cache=65000, ..., installasservice

when you type

>server /?

you get all the possibilities.

When you don't "installasservice", the server will try to run in DOS-mode.

Wayne

We have set up the cache. Thanks.

But we still have blackages in some Tables.

Is there an other chance to keep the
blockages in the tables low.

Instead of changing in SQL.

thanks wayne

Waldo

You could check the code and try to insert COMMIT-statements where it's safe to do so, but I don't encourage this treatement ... especially not on standard Navision-code.

Wayne

Yes it works better. Thanks.

It´s like a bus stop. Now there are much more buses,
instead of one.