Different user messages

ta5

Hi
I'm curious about the following, Nav 5.0, Native:

If a table is searched with a suboptimal key, sometimes the message "Searching the table xy.." is showed as a dialog, sometimes it is showed in the status line. Does anybody know when either of this messages is shown?

Btw: The message "Table xy is locked by..." also has these 2 possiblilities. We had an issue a few years ago an then the solution was that a dead lock and a normal lock made the difference.

We know that it actually makes no difference how the messages are shown, but we want to fine tune quite a big db and so we are looking for every hint...

Any input will be appreciated. Thanks
Thomas

kine

1) Differences can be between client version

2) Differences are between Native and SQL version

3) Differences can be in same client but when working with SQL table and with Temporary (Native) table in same application...

ta5

hmm, still a bit confused:
the installation is 5.0 native, no temporary tables used in the affected area :?

kriki

What is a "quite a big db"?

If you have to do some performance tuning, you should also check other things (even for a native DB):
-disks? how many disks do you use? In which RAID? If you have RAID5, you have already found a big performance problem.
-memory : you need about 1.5 GB and around 850MB for the DBcache.
-COMMITCache should be enabled.
-is the server/disks dedicated?
-CPU is not a problem on a dedicated system
-Do you have some Antivirus running on the system?
-try to remove some indexes in the tables. On native, this is quite difficult:you need to check all the code to see if an index is not used. A lot of indexes are used only for reporting, so by changing these reports to use a temptable or another index you can eliminate an index.
-...

ta5

Quite a big db / performance tuning:
The native db is about 20GB, performance is ok, but after the upgrade from 3.7 to 5.0 one heavy customized codeunit is too slow. Rest is ok.

Regards
Thomas