I have a huge pda 76 meg. The size refers to the nature of the data being returned, namely 1 dimensional arrays of size (1:999), and 2 dimensional arrays (1:99,1:10) etc. Although in reality the max size the pda would be populated to is approx 32k, in theory, a record may hold in its entirety 76 megs (when including all child records etc).
What happens, is that an external call is made from a client to the web services middleware and the middleware does a rpc to my natural 4 code via entire x. i populate the pda it goes back, entirex converts it to xml and sends it back as a web service. Problem is a query takes 60 seconds and this is with the pda being no where near full!
So how could i redesign this to overcome the huge size problem?
I was thinking of returning chunks/segments of the PDA, as in 0-10, 11-22, 22-33 etc to multiple calls from the middlware enitre x and then the middleware could amalgamate the segments into one. Would this make sense and speed things up?
Or if i used dynamic arrays? This would save me declaring huge arrays up front that may never get fully populated. But this still wont get over the problem of me reaching the full 76 meg in size and sending it across in one go.
Please help any suggestions?