Long loading time in grid with views

[u4ibm]

I`m using sgwt-ee 2.5 (last week`s nightly build) on Weblogic.

When i fetch from a view based datasource using a pure SQLDatasource,
It takes a long time to see the data, but when i fetch using SQLDeveloper it takes only few seconds.

Any idea why? Any best practice for that or known issues?

thanks

[u4ibm]

anyone?

thanks

[Isomorphic]

Start with some elementary first steps, such as looking at the logs to see where the time is spent.

[u4ibm]

in the slow loaded view, it seems like the "count(*)" takes a long time,
is it mendatory or can i turn this pre-fetch off?

[Isomorphic]

We use this size the scrollbar. It's possible to write custom code to get rid of it (see the explanation of progressive loading in the ResultSet docs). An enhancement is also planned to have the ability to turn this off as a built-in feature of SQLDataSource - use Feature Sponsorship if you need this by a particular date.

[u4ibm]

can`t u get the size from the result set? why having 2 queries?

thanks anyway :)

[Isomorphic]

Only by loading all the data, which is much much slower.