midprasanta

I found the reason. I set jdbc. fetch.size very low. That's why mysql was taking long time to send response back. It makes mysql connector in streaming mode. Now I have anothe issue. I can generate report for 115 files using SwapVirtualizer within 50 minutes. Total record count 5 million. This is in windows 7 server. When I am trying with same configuration, it is taking 1 day!!!. swap file is being incremented by block size of 4096 byte. It is lot of time. In windows in blick of eye, swap file size is incrementing great speed. Also I am executing report generation using threadpool. Firing 10 threads to jasper server at a time. Any performance tuning required for Linux. It is redhat enterprise.

I am using SwapFileVirtualizer to avoid OutOfMemory issue. However could notice that sqlquery is taking long time in status 'Writing to Net'. Where as when I run the query in sqlyog it is not taking much time. Is there any setting I can apply so that ResultSet can be received in single shot. I am using mysql 5.6 and jasper server 5.5.0

Can we not increase the buffer capacility so that file.buffer.os creation will be faster.

record is around 170000

Hi All, I am running jasper server 5.5 Trying to generate xls with multiple tab. Using SwapFileVirtualizerStoreFactory to improve performance. With below parameter. <property name="directory" value="C:/var/tempreportDir"/> <property name="blockSize" value="4096"/> <property name="minGrowCount" value="6400"/> Here it is taking around 10 mnts to generate and download the xls. One major time consuming I noticed was generating file.buffer.os files. It is taking maximum time. Any suggestion to improve the performanc ewill be greatly appreciated.