Bad performance on Bigdata

[amit.barkai]

Hi 

when queries return huge amount of data  ..

my queries return ~40 million and even more rows  ( a topic report - to give the user the ability to create any report he would like )

1.jasper fail to load all data ( even when changing the Ad-Hoc Cache limitation) - takes lots of time

2. machine is stating to work very slow

3.memory grows to 3GB and more

is jasper build for BigData? 

 

thanks

 

[ernestoo]

40 million rows is pretty big! I would say you have to replace the default ehcache implementation with the "BigMemory" product. Or at least look at tweaking ehcache settings in WEB-INF

 

[amit.barkai]

Thanks

is there any "BigMemory" product you can recommad ?

not sure i understood what you ment by tweaking ehcache settings in WEB-INF 

could you send me an example link ?