Slow compilation

Belias · **Posted:** Thu Mar 12, 2009 11:11 am

i have 2 questions: 1 now, when you import some objects in nav2009, they will be automatically compiled...after that you usually receive a message with the number of errors...in my case 1663...it's my record...anyway, nav does not mark the entries and you have to recompile everything another time.

now, the bigger problem: can someone explain to me why i've been waiting about 20 minutes to compile 933 tables?
maybe because indexed views are recreated everytime?if so, i don't like it...i can't waste my life compiling objects!! ](*,)

kriki · **Posted:** Thu Mar 12, 2009 11:35 am

In case you have a DB you use ONLY with the classic client (and NEVER with the RTC), you can change an DB-option:File=>Database=>Modify=>tab options=>Enable for Microsoft Dynamics NAV server to FALSE. This avoids that the objects are compiled when importing them.

Belias · **Posted:** Thu Mar 12, 2009 11:44 am

I am also using RTC...so i suppose there are no ways to avoid this...

kine · **Posted:** Thu Mar 12, 2009 4:04 pm

Belias wrote:

i have 2 questions: 1 now, when you import some objects in nav2009, they will be automatically compiled...after that you usually receive a message with the number of errors...in my case 1663...it's my record...anyway, nav does not mark the entries and you have to recompile everything another time.

now, the bigger problem: can someone explain to me why i've been waiting about 20 minutes to compile 933 tables?
maybe because indexed views are recreated everytime?if so, i don't like it...i can't waste my life compiling objects!! ](*,)

Because all code is translated into C#, it means writes into the new "system" tables, it means modify on the Blob, etc... it means that it take longer time than before... Try to use SQL profiler to check if there is something you can make faster.

Belias · **Posted:** Thu Mar 12, 2009 4:29 pm

kine wrote:

Belias wrote:

i have 2 questions: 1 now, when you import some objects in nav2009, they will be automatically compiled...after that you usually receive a message with the number of errors...in my case 1663...it's my record...anyway, nav does not mark the entries and you have to recompile everything another time.

now, the bigger problem: can someone explain to me why i've been waiting about 20 minutes to compile 933 tables?
maybe because indexed views are recreated everytime?if so, i don't like it...i can't waste my life compiling objects!! ](*,)

Because all code is translated into C#, it means writes into the new "system" tables, it means modify on the Blob, etc... it means that it take longer time than before... Try to use SQL profiler to check if there is something you can make faster.

you're right!!c# objects! #-o

BTW...
it's sad to say this, but i'm not so skilled...to use sql profiler and improve things...

maybe in the future...
thanks anyway...

mibuso.com

Slow compilation

Who is online