This is a migrated thread and some comments may be shown as answers.

VirtualQueryableCollectionView with filter causes infinity db queries

1 Answer 42 Views
GridView
This is a migrated thread and some comments may be shown as answers.
User1564
Top achievements
Rank 1
Veteran
User1564 asked on 02 Sep 2020, 11:44 AM

Hello,

I've got an issue with this function. I am using RadGrid together with a timebar, where I limit the time of the entries.
Data is from sql server using entity framework. Set Loadsize to 50

Now if I change timebar, sometimes it freezes and I see using sql profiler that it makes queries all the time every second.

 OFFSET 11000 ROWS FETCH NEXT 50 ROWS ONLY 

last one I checked
OFFSET 25200 ROWS FETCH NEXT 50 ROWS ONLY 

The user didn't interact because gui is frozen, but the queries still go on.

Seems to be a bug.

1 Answer, 1 is accepted

Sort by
0
User1564
Top achievements
Rank 1
Veteran
answered on 03 Sep 2020, 09:46 AM
Ok problem is solved. Had a for loop going through the grid.
Tags
GridView
Asked by
User1564
Top achievements
Rank 1
Veteran
Answers by
User1564
Top achievements
Rank 1
Veteran
Share this question
or