Grid select() performance issues

Vaadin 6 / 7 / 8
1

Hello all,

I hit a performance issue when using Grid select(), I’m using LazyQueryContainer as the data source my table have more than 100k items. I use Multi selection model, i need to programmatically select back the item which i store in a list after user check the item on check box and click sorting . But when i use the Grid.select(), it take a long time and from the log i saw the LazyQueryContainer loadItem() is calling from 0 to the totals items in my tables just to select back 2 items. So anyone go the same issues? Is there any alternatives way

loadItems(), startIndex = 0, count = 200. totalSize = 134262
loadItems(), startIndex = 200, count = 200. totalSize = 134262
loadItems(), startIndex = 400, count = 200. totalSize = 134262
loadItems(), startIndex = 600, count = 200. totalSize = 134262
loadItems(), startIndex = 800, count = 200. totalSize = 134262
...