Skip to main content



      Home
Home » Archived » BIRT » Cache Preferences
Cache Preferences [message #362564] Fri, 16 May 2008 14:53 Go to next message
Eclipse UserFriend
Via a Google search for "Cache Preferences", I found an archived BIRT
Developer Guide that contained information about setting Cache Preferences
for a dataset. This information is as follows:
How to set cache preferences
In Edit Data Set, choose Cache Preference.
Cache Preference appears.
To set cache preferences, choose Cache data set data for report preview.
BIRT Report Designer displays cache options.
Define data set size to cache:
To cache a portion of the data set, select Cache and use first.
BIRT Report Designer enables the field in which you can type an integer
defining the number of rows to cache.
Type an integer in the rows box.
To cache the entire result set, select Cache entire data set.
To clear the cache, choose Clear Cache.
BIRT displays a message stating the cache has been cleared.
Choose OK.

In BIRT 2.2.2, you cannot set Cache Preferences as described above. In
BIRT 2.2.2 under "Settings" for a dataset, you can indicate that all rows
from the datasource should be fetched, or you can specify a fixed number
of rows to fetch. Are the fetched rows cached automatically, or is there
a new way to define caching options in BIRT 2.2.2?
Re: Cache Preferences [message #362573 is a reply to message #362564] Sat, 17 May 2008 03:19 Go to previous messageGo to next message
Eclipse UserFriend
The cache preferences has been removed from dataset editor. You can set it
in Report Designe Preference:

Window->Preferences->Report Design->Preview->Data->Maximum number of rows to
display

The default value is 500 and in BIRT2.3.0 you can also set it in layout
preview page.

Tianli
Re: Cache Preferences [message #362577 is a reply to message #362573] Sat, 17 May 2008 03:39 Go to previous messageGo to next message
Eclipse UserFriend
Sorry for the mistaken setting preference in former answer, the preview
page in data set editor will use row number set in data set preference
page to cache the data set into memory:

Windows->Preferences->Data Set Editor->Maximum number of rows to display
Re: Cache Preferences [message #362610 is a reply to message #362577] Mon, 19 May 2008 11:36 Go to previous messageGo to next message
Eclipse UserFriend
It was my understanding that "Maximum Number of Rows to Display" under
"Windows/Preferences/Report Design/Data Set Editor" applies only to the
"Preview Results" function for an individual data set when you want to
preview the data returned by the SQL Query. Is this not true?

What I want to define is the number of data rows to cache when I select a
report's "Preview" tab. I would like to be able to make incremental
report design changes and test each change against a small subset of the
rows in a dataset without having to re-execute the SQL against the entire
dataset.
Re: Cache Preferences [message #362656 is a reply to message #362610] Tue, 20 May 2008 11:26 Go to previous message
Eclipse UserFriend
There are three rows limit setting:
1, fetch rows from data source, the setting works on individual dataset.
It will define how many rows to fetch from a datasource.
2, maximum number of rows to display in preview of preference, the setting
works when previewing the report in layout.
3, maximum number of rows to display in dataset editor of preference, the
setting will works on all the datasets in the report and only take effect
on the preview of dataset.
These three settings will not do cache job.

As your requirement I think you may set the second max rows limit when
previewing a report. Because BIRT will do the cache for you all the time.
If you want to set the cache by yourself you can set a
DataEngine.DATA_SET_CACHE_ROW_LIMIT AppContext to DataEngine.

Tianli
Previous Topic:Sending parameters to a report using URL
Next Topic:SEAM and Birt integration
Goto Forum:
  


Current Time: Tue Sep 16 13:17:25 EDT 2025

Powered by FUDForum. Page generated in 0.03980 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top