Moving Recordset to client machine from business login unit

[miq]

hi,

I want to learn efficient ways to transfer Recordset from middle tier to the client which is a different machine.
How can i achieve this with minimum network traffic.

middle tier gets recordset from DB tier using Client side cursor so, i guess the resulting recordset is at the middle tier (business tier). Calls from client to business tier can take all of the network resources by moving recordset to the client machine this continuous network traffic can be avoided but for this a heavy load while transferring recordset to client occurs bearing in mind about 10 to 100 clients can have access to the server at a time. Which makes recordset transfer load * 100. How can i minimize this impact on performance.

XML ??? or save recordset to disk and copy that file to all clients?? what else ????


Help !!!

Bye
miq

 

[SemperFiDownUnda]

ADODB Recordsets have special marshelling to actually copy the entire recordsets, not just the interface, to the client. If you don't want to do that then I'd say send down XML to the client but I'm not sure if you'd have a very big saving of network traffic doing this.