A workspace that stars with a SQL-creator works flawlessly when executed from workbench or server-app.
It executes in a matter of seconds. Especially the server-app is highly efficient.
We are now testing to have it run via webhook in a stored procedure in the SQL-database.
Below is the log with timestamps. Row 91 seems to halt the execution for ~100 seconds.
Can I optimize the transformer/call or is it more likely to arise in a conflict between committing and selecting in the SQL database.
902020-5-26 13:31:08 | Microsoft SQL Server Non-Spatial Reader: Trying to connect using Microsoft OLE DB Driver for SQL Server...912020-5-26 13:31:08 | MSSQL_ADO reader: Building features into bulk mode features922020-5-26 13:32:47 | Microsoft SQL Server Non-Spatial Reader: Database read complete. Retrieved 6 feature(s)932020-5-26 13:32:47 | Logger: ------------ LOGGER --------------------