Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Setting cache in BIRT(Setting cache in BIRT)
Setting cache in BIRT [message #629226] Mon, 27 September 2010 10:08 Go to next message
Gaurav Sahni is currently offline Gaurav Sahni
Messages: 19
Registered: September 2010
Junior Member
Hi jason


As you mentioned in another thread that how to set up the cache so i have used these following enteries for setting the cache
task.getAppContext().put("org.eclipse.birt.data.engine.dataset.cache.option ", "Yes");
task.getAppContext().put("org.eclipse.birt.data.cache.RowLimit ", new Integer(500));
task.getAppContext().put("org.eclipse.birt.data.cache.memory ", new Integer(500));


it also increased the performance little bit Please let me know is this the right way to use the caching in BIRT servlet
Re: Setting cache in BIRT [message #629285 is a reply to message #629226] Mon, 27 September 2010 11:54 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

The first option you have has been deprecated and is not needed. The
second two options have to do with design time caching and really should
not be used in runtime. Try using:

"org.eclipse.birt.data.query.ResultBufferSize"

This setting determines how much of the data is cached in memory before
writing to disk. It defaults to 10mb. Set it to an integer.

Jason


On 9/27/2010 10:08 AM, Gaurav Sahni wrote:
> Hi jason
>
> As you mentioned in another thread that how to set up the cache so i
> have used these following enteries for setting the cache
> task.getAppContext().put("org.eclipse.birt.data.engine.dataset.cache.option
> ", "Yes");
> task.getAppContext().put("org.eclipse.birt.data.cache.RowLimit ", new
> Integer(500));
> task.getAppContext().put("org.eclipse.birt.data.cache.memory ", new
> Integer(500));
>
>
> it also increased the performance little bit Please let me know is this
> the right way to use the caching in BIRT servlet
>
Re: Setting cache in BIRT [message #629561 is a reply to message #629285] Tue, 28 September 2010 13:16 Go to previous messageGo to next message
Gaurav Sahni is currently offline Gaurav Sahni
Messages: 19
Registered: September 2010
Junior Member
Hi jason

as you mention the following two options should not be used runtime what does it mean and also it runs reports faster if i set these two parameter

task.getAppContext().put("org.eclipse.birt.data.cache.RowLimit ", new Integer(500));
task.getAppContext().put("org.eclipse.birt.data.cache.memory ", new Integer(500));

and while setting "org.eclipse.birt.data.query.ResultBufferSize"

for 100 mb it does not show any performance improvements and aslo in log it say cache use 0 seconds something like that

andl also if we use the birt viewer instaed of writing own servlet then how to set this cache in Birt Viewer

Thanks for all replies


Re: Setting cache in BIRT [message #629792 is a reply to message #629561] Wed, 29 September 2010 10:53 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

The first two options have to do with saving the dataset in a cache,
which means if the data changes you will not get the updated data.

The last option if set to 100 should not write to disk cache unless the
100 mb is used.

I have not tried the following data engine setting, but it may be worth
a try:

task.getAppContext().put("org.eclipse.birt.data.memoryusage ","org.eclipse.birt.data.memoryusage.Aggressive");

Jason



On 9/28/2010 1:16 PM, Gaurav Sahni wrote:
> Hi jason
> as you mention the following two options should not be used runtime what
> does it mean and also it runs reports faster if i set these two parameter
>
> task.getAppContext().put("org.eclipse.birt.data.cache.RowLimit ", new
> Integer(500));
> task.getAppContext().put("org.eclipse.birt.data.cache.memory ", new
> Integer(500));
>
> and while setting "org.eclipse.birt.data.query.ResultBufferSize"
>
> for 100 mb it does not show any performance improvements and aslo in log
> it say cache use 0 seconds something like that
> andl also if we use the birt viewer instaed of writing own servlet then
> how to set this cache in Birt Viewer
>
> Thanks for all replies
>
>
>
Re: Setting cache in BIRT [message #901689 is a reply to message #629285] Tue, 14 August 2012 03:44 Go to previous messageGo to next message
sidharth mv is currently offline sidharth mv
Messages: 9
Registered: July 2012
Location: India
Junior Member

Hello Jason,

I am using BIRT runtime to view reports. So when I use complex queries with huge data, I need a caching mechanism for repeated access. Can you suggest how to achieve this. I have tried putting in URL the following parameter __overwrite. But I am passing parameters within report. Is it possible to define for each report to use a 30MB or 50MB memory to use as cache? So that repeated processing can avoid.

Thanks in advance,
Sidharth
Re: Setting cache in BIRT [message #901871 is a reply to message #901689] Tue, 14 August 2012 16:54 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

BIRT by default caches datasets already. If you mean by multiple
sessions your can always save the rptdocument and re-render it. Just
use &__document=docname.rptdesign in the URL of the viewer.

Jason

On 8/14/2012 3:44 AM, sidharth mv wrote:
> Hello Jason,
>
> I am using BIRT runtime to view reports. So when I use complex queries
> with huge data, I need a caching mechanism for repeated access. Can you
> suggest how to achieve this. I have tried putting in URL the following
> parameter __overwrite. But I am passing parameters within report. Is it
> possible to define for each report to use a 30MB or 50MB memory to use
> as cache? So that repeated processing can avoid.
>
> Thanks in advance,
> Sidharth
Previous Topic:series in radarchart with less than 3 values
Next Topic:Export report to excel
Goto Forum:
  


Current Time: Thu Jul 24 02:45:12 EDT 2014

Powered by FUDForum. Page generated in 0.01982 seconds