Hello,

Not so recently I noticed that some apps tend to take a long time when publishing using VS Code even when they do not have any upgrade code. The reason of slowdown is SQL queries that go over all large table entries and makes sure that both main table and extension table has only records with matching key values. This is needed because app could be uninstalled temporarily and then extension table may not be updated.

If app was uninstalled when publishing app from VS Code BC should check if any table inserts, renames or deletions happened since app was last uninstalled (keep statistic per non-extension table - last operation timestamp and another statistic - last operation timestamp when table was uninstalled) and only then do those long running SQL queries. Apps are rarely uninstalled manually and long running queries make extension publish run for 10 minutes or more sometimes.

Thanks.