K
kirchner
Guest
The MSS dataserver does not need to run in the same host as the database. You can do as you please. But if you have 3 different machines you pay at least 2 network hops for each db access. In my experience with MSS DS (ORA DS as well) your bandwith does not matter much. It's much more a latency thing. It also depends on you code. A "FOR EACH bigtable NO-LOCK" will stream the data to the client and you get reasonable throughput. In this case the client process (prowin32, _progres) is usually the bottleneck and will 100% one of you CPU cores. The same code with EXCLUSIVE-LOCK will request one record at a time from the database and you get 0 performance. The more chatty you code is to the database the worse your perf. Just monitor how many interactions with the server your client is doing. Ideally you would do everything in bulk, but you can't do that for data modifications unless you use SPs or SEND-SQL-STATEMENT.
Continue reading...
Continue reading...