I have noticed that performing just about any function in Google Apps scripts is quite slow, e.g.
function showSidebar() {
DocumentApp.getUi().showSidebar(HtmlService.createHtmlOutputFromFile("test.html"));
}
In execution logs is showing up as taking over 1 second to complete, having a 1000ms+ penalty on any additional calls our add on has to make it just awful…
And then network calls seem to have a 1 second delay after responding (the server confirms it responds to the request in under 50ms).
Is there anything that can be done to make the whole program faster? It almost seems like its in a slow debug mode?