Out of memory

[#1]

Hi

I have a qvd of 8millions record which has only one column. Only i am checking is count(column), len(column) in Straight table. It works fine for 3million record but when it crosses 3 million - chart gave OUT OF MEMORY error. Is there any solution to get rid off with?

Thanks in advance.

[#2]

Hai,

This case at lease u would have 16 gb ram  and 8 cpu core

[#3]

Yes, already tried on 8 cpu core & 16gb ram where there it consumes 15gb of RAM.

[kaushiknsolanki · Accepted solution]

Hi Navneet,

     I would suggest you to do following things for getting the count and sure your performance will be much much better.

     assume following is your code.

     load Field From XYZ;

     you are using the count(Field) in your chart. But try below to overcome the problem.

     Load Field,'1' as Flag From XYZ;

     now use the below expression.

     sum(Flag) to get the count.

     Hope the idea is clear.

     The Count function is resource intensive, where as Sum is not. So whenever you need count of field, use the above logic to improve the performance and reduce the load on chart as well as application.

Regards,

Kaushik Solanki

[#5]

Perfect Kaushik. Thanks for sharing this concept.