Android Question Is there a memory limitation for RDC when retrieve data?

[incendio]

Hi guys,

I am planning to use RDC (Remote Database Connector) to retrieve data from server.
On server, there is a table with one blob field.
Blob field could contains 1MB or 2 MB data per record. Table could contains hundreds of data.

Is there any memory problem or any others problem when retrieve this big data via RDC?

Thanks in advance.

 

[Erel]

The server response (the result set) is held in memory. So you should limit each request to about 8-10 mb to avoid memory issues.

 

[incendio]

The server response (the result set) is held in memory. So you should limit each request to about 8-10 mb to avoid memory issues.

How do I increase memory space in server side?

If I remember correctly, with RDC, I think, there is a parameter to set for java memory requirement, maybe its default value is 256MB, is this a memory for held result set?

With jRDC, how to do that?

 

[Erel]

My previous message was not clear enough. I was talking about the client side. The server can easily handle larger requests.

 

[incendio]

Can I increase a memory limit on client side? 8-10MB seem to little, around 50MB is ideal for me.

 

[Erel]

You can ask the OS to allocate more memory with the largeHeap attribute.

 

[incendio]

I remembered using this attribute when tried to retrieved about 60K (no blob type) data from server. So, this is the trick, thanks for the tip.