You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am using Azure Data Studio 1.48.0 ... which is the last version.
It works fine for me except manipulation with Result Set after SQL query execution.
In my case table is big and have thousands of records and I would like to filter it in 'Results'.
The issue is that it has some limitation. E.g. when I query a table and select column with int type I can filter it only when the records number are bellow 60000. If I select e.g. 80000 it fails to filter.
e.g.
select top 70000 INVENTORYID from INVENTORY
note: inventoryid is integer
Symptom:
I click on filter icon,
I've got a list of inventoryid,
I select one of it and click OK
Selected inventoryid was not displayed as expected
I run on Windows server 2019. It has a plenty of resources.
It looks like 'memory' allocation issue inside ADS. I tried to modify settings to increase memory ... I increased Memory Data Processing Threshold till 99999999 but it didn't help.
Could you advice?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I am using Azure Data Studio 1.48.0 ... which is the last version.
It works fine for me except manipulation with Result Set after SQL query execution.
In my case table is big and have thousands of records and I would like to filter it in 'Results'.
The issue is that it has some limitation. E.g. when I query a table and select column with int type I can filter it only when the records number are bellow 60000. If I select e.g. 80000 it fails to filter.
e.g.
select top 70000 INVENTORYID from INVENTORY
note: inventoryid is integer
Symptom:
I click on filter icon,
I've got a list of inventoryid,
I select one of it and click OK
Selected inventoryid was not displayed as expected
I run on Windows server 2019. It has a plenty of resources.
It looks like 'memory' allocation issue inside ADS. I tried to modify settings to increase memory ... I increased Memory Data Processing Threshold till 99999999 but it didn't help.
Could you advice?
Beta Was this translation helpful? Give feedback.
All reactions