I used JPAContainer and wrote a simple application to display the data in a DB table. Its performance is very bad. Every time, I scroll up/down it takes several minutes to load the data. There are no much data in the that table (around 100 records).
The code looks like this:
InitialContext ic = new InitialContext();
CmsConfigProviderBean cmsConfigProvider = (CmsConfigProviderBean) ic.lookup("java:module/CmsConfigProviderBean");
JPAContainer<CmsConfig> cmsConfigContainer = new JPAContainer<CmsConfig>(CmsConfig.class);
cmsConfigContainer.setEntityProvider(cmsConfigProvider);
Table listTable = new Table();
listTable.setContainerDataSource(cmsConfigContainer);
VerticalLayout layout = new VerticalLayout();
layout.setSizeFull();
layout.addComponent(listTable);
getMainWindow().setContent(layout);
When I switch to SQLContainer, the performance is back to normal.
Should I apply any special configuration to make it perform better?
Regards
Farid