On the developer computer the process of selecting takes about 44-45 msec. When I deploye wcf to your host, the operation takes from 2 sec - to 16 sec with the same db. is it ok or i'm doing something wrong? Thanks ps. At the same time only one person works with db. DB holds no more than 1000 records
A shared database server at a remote location is always going to be slower than a local development server running on the computer in front of you. Some of that time (when it takes 16 seconds) could be application related as well. Hard to say anything for certain without any details.
could also be network latency. as far as I know, our mySQL servers are running with very little CPU usage.
