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