I know for indexing and it is not a question. I am experienced programmer years 20+ with database software and I know how to make good index. I am pretty new with WD. I am also write about query's which are very fast. Off course, they can not be fast if index is improper. I talk about reading/writing data on network when many users read/write data into same tables. Maybe query is faster on network especially with HF/CS 'cause query is something like dataset from VB/Delphi/.... copy of original data and used only once per request on network and if I am understand only changed data are write back into database.
But, again, followed my first question I need answer from you experienced than me with WD and already distributed applications, 'cause I don't have yet any application distributed which is developed with WD.