TableQuery is too slow with big Tables (millions of rows)

Vaadin 6 / 7 / 8 Framework Data Binding
1

Hi everyone,

I’m using Vaadin 6.6.2 + SQLContainer 1.1.0. I need to load TableQuery with big tables to manage them (admin). The problem is related with tables which has a lot of data (million/s of rows)


    		TableQuery tq2= new TableQuery(TABLE_NAME,DBUtils.getConnectionPool(),new OracleGenerator(primaryKeyList));
    		containerSearch= new SQLContainer(tq2);

Is there other object like TableQuery to work with big tables? Any sugestion?

Thanks in advance!

2

Ideas?

Thanks in advance.

3

Hi,

I don’t have a solution for you, just wanted to point out that the Table component in Vaadin has a limitation on row count somewhere around 500k rows. So even if you would get the TableQuery functioning, what would you use it for?

Anyways, scrolling through millions of rows will probably not be a very nice experience to the user, so you might want to consider adjusting your use case a bit. Maybe use some pre-filtering on the fetched data set?

4

Thank for the reply Teppo. Finally i’m using a form with data that the user must to complete in order to make a SQL, after that I’ll collect data with FreeFormQuery.

Maybe TableQuery should use some filter like this?

Regards.