Slow when users permissions is restricktet

welanderwelander Member Posts: 20
Hi

I have a Native NAV 5.0 solution with about 200 companys in the database
there is a batch job in the solution which takes a few sec. to run if the user has no restricktions if the user are restrictet only to acces a few company's the same batch takes up to 3 houres the first time it is run and then a few sec. the next time. Why?

Best Regards
Lars Welander

Comments

  • krikikriki Member, Moderator Posts: 9,110
    SQL or native? I suppose SQL.

    In case you are using Enhanced security model, it might be a good idea to switch to standard security model. It is the only motive I can think of for this problem.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.