D
dbeavon
Guest
After my previous post, I tried a faster way to get that SELECT statement response back from the database and now my responses come in under 10 ms, which seems much more reasonable. It kept bothering me that my 150 ms duration was so extremely long - that was taking even longer than round-trips that use classic state-free appserver. I discovered the reason for the delay: the ADO.Net method I was using ("FillSchema" on a data adapter) was doing quite a lot more work on the OE server than when I used another simple method ("ExecuteScalar"). Either way, the network latency appears to be a small proportion of the overhead. It is obvious that a lot of CPU is being used for these round-trips -- both on the server and on the client.
Continue reading...
Continue reading...