Skip to main content
Question

SQL reader halts execution


mathiku
Contributor
Forum|alt.badge.img+7

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 --------------------

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings