Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Filtering issue in Result Set #26166

Open
Susja opened this issue Jan 26, 2025 · 0 comments
Open

Filtering issue in Result Set #26166

Susja opened this issue Jan 26, 2025 · 0 comments

Comments

@Susja
Copy link

Susja commented Jan 26, 2025

Discussed in #25663

Originally posted by Susja June 3, 2024
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 advise?


Update: I increased maxrows and memory threshold till 9999999 but the issue is still there…

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant