SQLContainer

Vaadin 6 / 7 / 8 Framework Data Binding
1

Hi
I’m studying vaadin(6.6.0) begin whit Address Book,and use SQLContainer(1.1.0) to connect Mysql(5.5) database.
I got some problems,when i click the table header to order the items, the console prints every time:

Fetching count…
DB → begin transaction
DB → SELECT COUNT(*) FROM personaddress
DB → commit
DB → begin transaction
DB → SELECT * FROM personaddress ORDER BY “email” ASC LIMIT 200 OFFSET 0
DB → commit

Is that query database every time?Isn’t it a waste of resources?Still the reason is that it is internal mechanism of SQLContainer.
Thanks

PS:Basically, all events will be the same.

2

SQLContainer performs sorting using a database query instead if in-memory to be able to support lazy loading.