search

flowsforapex / apex-flowsforapex

Flows for APEX - Model and run process flows all within Oracle APEX!
https://flowsforapex.org
Other
83 stars 42 forks source link

[bug]: Drastically increased query time #775

Open jobaja opened 4 days ago

jobaja commented 4 days ago

Flows for APEX version

5.1.1

Oracle Database version

21c

Oracle APEX version

24.1

Have you used the BPMN-Linter in Flow Designer to Validate your Diagram?

Yes

What happened?

In the last released version the FLOW_INSTANCE_DETAILS_VW view was altered to add the user_task this increased our query time on the view from 0.06 seconds to 37 seconds in our infrastructure.

Imagen de WhatsApp 2024-11-20 a las 12 11 01_5546cdb9

Imagen de WhatsApp 2024-11-20 a las 12 11 11_9964b439

Steps to reproduce

No response

Expected behaviour

No response

rallen2010 commented 4 days ago

Could you confirm which Flows for APEX version you are now running- the report above says 5.1.1. Have you just upgraded to 24.1??

rallen2010 commented 3 days ago

Please contact me & we can set up a Zoom call to diagnose.. Richard at Flowquest dot net.