Altering Databases - Options Tab - Find as you type

CAL
CAL Member Posts: 10
edited 2005-05-26 in NAV/Navision Classic Client
if you switch off “Find as you type” on the Alter Database function, is it correct to assume that there will be a significant speed improvement on the database? Are there any implications in doing this?

Comments

  • kine
    kine Member Posts: 12,562
    Yes, because each Char you enter call the select on SQL which is very costly. If you disable this, it means, that there will be only one select after you hit "Find" or enter... and if you count users, which are using this function in 1 hour and what they are doing, you can cal the performance gain (it depend how havilly they are searching the data etc...)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories