SQL parsing take much longer time using PostgreSQLSyntaxProvider
We have a client application where we are using Active Query Builder 2 .NET Edition v.2.9.5.704.
Previously we had Active Query Builder 2 .NET Edition v.2.8.0.649 used with MySQLSyntaxProvider.
But after we migrated our database to postgresql, we updated our client application for database changes. And used PostgreSQLSyntaxProvider (Active Query Builder 2 .NET Edition v.2.9.5.704).
But it seems that the query parsing time for complex queries with the following method drastically increased:
try
{
queryBuilder1.SQL = sqlQuery;
}
catch (Exception ex)
{
return false;
}
The equivalent query for MySql was loading/parsing in almost just 3-4 secs but in Postgresql it is now taking significant amount of time (40-50 secs) to parse the query.
We are loading metadata programmatically and using OfflineMode = true;
Previously we had Active Query Builder 2 .NET Edition v.2.8.0.649 used with MySQLSyntaxProvider.
But after we migrated our database to postgresql, we updated our client application for database changes. And used PostgreSQLSyntaxProvider (Active Query Builder 2 .NET Edition v.2.9.5.704).
But it seems that the query parsing time for complex queries with the following method drastically increased:
try
{
queryBuilder1.SQL = sqlQuery;
}
catch (Exception ex)
{
return false;
}
The equivalent query for MySql was loading/parsing in almost just 3-4 secs but in Postgresql it is now taking significant amount of time (40-50 secs) to parse the query.
We are loading metadata programmatically and using OfflineMode = true;
PostgreSQL SQL syntax is much more complicated than MySQL, so PostgreSQL parser might be considerably slower than MySQL. You can send us the sample query that parses too slow, so will be able to profile PostgreSQL parser on it.