Slow SQL Parsing with OracleSyntaxProvider
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
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
I could solve the problem. It was not related to Active Query Builder. Sorry for bothering you.
Best regards
pdv-software