I am working on an application that is a front-end for a SQL database.
While it is not an immediate requirement, the application will probably be
required to be able to connect via the internet at a later date, so we are
implementing the data connections via remoting. The remoting is implemented
via the HTTP channel, with the binary formatter. We have noticed, however,
that the remoting calls seemed to be much slower that the OLEDB calls, so I
wrote a standalone test app and checked. In the test app, the OLEDB calls
get 11583 records in 5 seconds on average, while it takes the remoting over
47 seconds to get the same data. Both the OLEDB and the remoting are
calling the exact same stored procedure with the exact same parameters.
Can anyone tell me why the remoting is so much slower, and how I can make it
faster?
TIA
Ron L.