Active Query Builder support area

Visual query builder - Aggregate function slow

Avatar
  • updated
  • Completed

Hello,

A customer using the visual query builder noticed when he is using it with his linked servers, the aggregate function when clicked freezes up. It seems to be searching across his servers since it thinks for 2-5 minutes. The sort, alias functions work normally, not sure why the aggregate would need to search since the table has already been specified.

They are connecting to SQL server, all his teammates experience this issue and for all tables.

Please let me know if there are more details needed.

Thanks,

April

Avatar

Hello April,

I've changed the QueryBuilder behaviour, now it tries to load custom aggregate functions only from currently connected server, and does not dive into linked servers.

The fresh distribs with the fix will be released in next few days.

Avatar
Andrey Zavyalov, PM

Hello,


The fixed version is available for downloading now.

Please confirm that the bug is fixed on your side.

Avatar
April P

Thank you!

Avatar
MargaritaW

Good morning. Would you please confirm that this fix is in Version 3?

Avatar
Andrey Zavyalov, PM

Hello,

Yes, I confirm that.

Avatar
MargaritaW

Thank you !!!