I have an interface that provides data, with two implentations, one getting
data from sql2k, one from text files. i wrapped the interface with a web
service and client proxy, created two web services for testing, one wrapping
the text data provider, the other wrapping the db provider.
Locally, without the web service layer, the text provider is faster in a
single user scenario than sql2k, both very fast though.
Thru the web service layer, text data implementation calls take about 5x as
long (10 seconds vs. 2 secs) as the sql2k data provider, even though they
are returning the exact same information back to the proxy. Even running
everything on the same machine, the text data provider is slow thru the web
service, 5-6 secs for my standard use case.
My text provider does a lot of file i/o, opening, seeking, reading, closing,
start over, am guessing this is why. Is there anything I can do to speed
things up? The service is hitting text files outside the web application
dir, could that be it?
Thanks in advance!
Derrick