Slow when users permissions is restricktet

welander

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

kriki

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.