Home > Forum > Rules, JS, SQL > Data row column without FROM "blocked" by some other statement?

Data row column without FROM "blocked" by some other statement?

0

04.02.2025

15:56

Hi everyone,

I will try to explain the behavior as good as I can but I don't have any explanation for it. Maybe someone else does and has an idea how I can track the 'culprit' / improve the behavior.

We have an item list with related documents. This item list has a data row column which outputs an HTML fragment for the current row to trigger a rename function.

select '
case SUBSTRING('{USERLAN}',1,2)
when 'de' then 'Umbenennen'
else 'Rename'
end
+'">
'
AS Rename

The only variable is the user language, there's no FROM, so it should be executed really fast.
For whatever reason so the diagnostic log shows that the execution for one row took 87ms seconds while another took 4279ms.

I don't have the slightest idea, why this happened, how I can track this or how to prevent it.

My best guess is, that a bulk of SQL commands needed to be executed and this one was in a queue which execution was delayed.

The version is WEBCON BPS 2023.1.2.99.

Best regards,
Daniel

05.02.2025

08:34

Hi Daniel,
I don't know if this will help you but I checked your query on exactly the same version (ver. 2023.1.2.99) and on the same query.

It works really fast (screenshot). The list has 50 rows.

Have you tried putting the query there without any conditions and text joins, e.g. SELECT 'test'.

regards,
Jacek

Solution (0)

Helpful (0)

Wrong answer (0)

05.02.2025

17:27

In reply to: Jacek Wojnar

Hi Jacek,

there seems to be something of with the server or

after restarting the MSSQLServer the execution time of these statements was down to 1ms. This afternoon it was back to 45ms accompanied by a spark in the CPU time of the SQL server. The SQL server didn't even hit the maximum allowed RAM.

We will have to investigate it further.

If I find something worth sharing I will update this post.

Best regards,
Daniel

Solution (0)

Helpful (0)

Wrong answer (0)

Privacy overview