Very long time publishing al extension

(0) Share

Report

Posted on by TiamaT

Hello,

I'm new in AL development and i've 2 extensions for BC. One is for all the tables extensions (new field, new tables, indexes) and one another for the logic.

My first extension is big, with more than 100 tables extensions, and 60 new tables. Every time i have a change to do on this extension, i have 2 hours for publishing it on the production database. The publication recreate every indexes, so it takes a long time even if I have a very small modified field on a single table. My question is, can i publish it without consuming this long time ?

i try the 'schemaUpdateMode option in the lauch.json with sync, forceSync, etc ...

Thank for your help.

I have the same question (1)

All responses (10)

Answers (1)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Are you in Business Central online or on prem?

Was this reply helpful? Yes No
TiamaT 20 on at

Like (0)

Report

I'm on prem

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Have you checked the performance monitor on your SQL server and your middle tier server when you do a publish?

To me it looks like your servers are drained with resources.

Was this reply helpful? Yes No
TiamaT 20 on at

Like (0)

Report

yes i see a lot of long request every time i publish.

It's altering every time the indexes

Message Action completed successfully, but it took longer than the given threshold.
Execution time: 12304 ms
Threshold: 750 ms
Message: Long running SQL statement
Task ID: 2
Connection ID: 27
SQL server session ID: 75
Client Type: WebServiceClient
Database Server Name: LOCALHOST
Database Name: BC-xxxxxxxxx
Current Company Name:

Statement: IF EXISTS (SELECT * FROM sys.indexes idx WHERE idx.is_disabled = 1 AND idx.[name] = N'$ExtKey4' AND idx.object_id = OBJECT_ID(N'XXXXXXX$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972'))

ALTER INDEX "$ExtKey4" ON "SQLDATABASE".dbo."XXXXXXX$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972" REBUILD;

....

my database is over 500Gb with 8 companies, and it tooks 2 hours

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

And the time is also two hours even when you use schema update mode synchronize?

You do not uninstall the extension for every publish you do?

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Did you publish directly in VS Code?

Have you tried using the Publish command in the Business Central Administration Shell?

More details:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-how-publish-and-install-an-extension-v2#to-publish-and-synchronize-an-extension

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
TiamaT 20 on at

Like (0)

Report

yes that's it ! almost 10 sec with the sync-navapp cmdlet !

thank you

do you know why when i publish with vscode it took so long ?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

I'm sorry that I don't know the details. I encountered this problem during the NAV 2018 extension v1.
Much faster from the Business Central Administration Shell.

Was this reply helpful? Yes No
TiamaT 20 on at

Like (0)

Report

ok thank you for your answer , and for your website too, i found a lot of interesting informations ;)

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

Hi,

Pls check you System processing speed and resources.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No