|
Re: DataSet used by more that one table/grid [message #491761 is a reply to message #491728] |
Thu, 15 October 2009 17:10 |
|
Tero,
Datasets should be being cached unless the queries are parameterized and
the parameter changes. You can also bind different tables to one table
and they share the same bindings and dataset.
Jason
tero wrote:
> Hello,
>
> In a big report I have different tables in different report pages (same
> report) where some of them are using the same DataSet.
> Will the SQL query (or the scripted data source in this case, which has
> a database connection) run multiple times (for each table) or only once
> and been cached for the calls to come?
>
> In case it is (by default) not being cached, is there a way to do it?
>
> I am trying to improve performance and the biggest delay occurs while
> retrieving the data:
> scripted data set (open/fetch) -> java class -> database -> java class
> -> data set
> Depending on that I would either design the connection to retrieve most
> of the data with few queries (if cached).
> or
> make atomic queries which will serve individual tables (no cache,
> datasets (open/fetch) called multiple times).
>
> Thanks!
> Tero
|
|
|
Powered by
FUDForum. Page generated in 0.03269 seconds