PCO Query Heap Space

[viniciuscrx]

Hello,

I'm having some trouble with big mass of data comming out of a pcoquery, when I'm running the transaction in MII I get the Heap Space error message. The project I have been working on needs to handle with more than one hundred thousand registries, is it a problem to be using the pco query for this kind of query? If no, how can I solve this heap space error?

[agentry_src]

First question your assumptions. Why do you need 100k registries to be handled by your pcoquery? Perhaps there is a more efficient way of selecting your dataset than grabbing such a large chunk.

What do you need that data for? Depending on your datasource, you may set up a filter there rather than pulling all the data to process.

Can you provide more details on your environment, datasource, data type, and end result you desire? Also what version of MII are you working with and any related system information?

Regards, Mike Appleby

[viniciuscrx]

Hey Mike,

Thank you for your answer. My need for a 100k registries comes from the request of a cliente that needs to have a month view of a few tags that are collected and stored every minute. Actually this amount of data makes any handling very difficult, I have been able to retrieve 40k registries but drawing a chart is basically impossible. My solution for this problem is using interpolation to drastically reduce the number of points to a bearable amount.

Thanks,

Vinicius Cruz Ribeiro