Active Query Builder support area

Slow SQL Parsing with OracleSyntaxProvider

Avatar
  • updated
  • Completed
Hello,
we are facing problems with SQL parsing with the Oracle Syntax Provider version 2.9.5.703. We have a huge SQL statement from a customer that consists of 13 Unions and 50 sub selects. In a previous version (2.9.3.700) the parsing took around 5 to 6 seconds. Now with the 2.9.5.703 version the same SQL statement parsing takes 10 to 12 seconds. Do you know about the problem or do you know any solution/workaround? Unfortunately I cannnot provide you the statement because it is customer related.
Thank you in advance

Best regards
pdv-software
Avatar
Andrey Zavyalov, PM
Hello,

Can you submit a support request in the Support Center and privately send this query (or similar one) to us for investigation? We need to profile parsing of this query and will find the reason of performance degradation.
Avatar
pdv-software
Hello,

I could solve the problem. It was not related to Active Query Builder. Sorry for bothering you.

Best regards
pdv-software