is Count still used in DataProvider ?

Flow
21

Also. I see another issue here. The query is getting executed twice

22 
    select
        c1_0.id,
        c1_0.address,
        c1_0.city,
        c1_0.contact_name,
        c1_0.country,
        c1_0.created_date,
        c1_0.customer_name,
        c1_0.last_modified_date,
        c1_0.postal_code 
    from
        customer_entity c1_0 offset ? rows fetch first ? rows only
Hibernate: 
    select
        count(c1_0.id) 
    from
        customer_entity c1_0
Hibernate: 
    select
        c1_0.id,
        c1_0.address,
        c1_0.city,
        c1_0.contact_name,
        c1_0.country,
        c1_0.created_date,
        c1_0.customer_name,
        c1_0.last_modified_date,
        c1_0.postal_code 
    from
        customer_entity c1_0 offset ? rows fetch first ? rows only
Hibernate: 
    select
        count(c1_0.id) 
    from
        customer_entity c1_0
23

That sounds potentially like this one: Components with data provider issue double fetch request if a filter is set · Issue #4345 · vaadin/flow · GitHub

24

yes same issue

25

updated the issue with my issue. Looks it is there for a long time

26

My observation is, it is happening when there are more than 50 records in the table

27

That means, everyone using Grid have this issue

28

The default pagesize is 50

29

if your UI displays more than 50 rows it will execute the fetch twice

30

Call

grid.setPageSize(200); // or whatever number of rows you are displaying
31

Then you will get only one fetch call

32

If I set the value to 10, it is making 8 calls

33

Then there are probabyl 80 rows visible

34

is visiblity depends on the grid size/scrren size ?

35

yes it fetched 80 rows but I need only 10 at a time

36

yes

37

so how this pageSize works ? Looks there is some indirect relationship with row count

38

when there are 1000 records, and pagesize = 100, how many times the query will execute ? 10 times or 10*2 = 20 times ?

39

If 100 rows are visible in the grid the there will be one query

40

if you start scrolling it will reload