Hmm, this is somewhere I havent been before, so is interesting from that point of view. The database contains orders to be picked from a warehouse and delivered to shipping. Both used to be on a LAN, but the company is now going to use two remote warehouses.

I'm limited with what I can do to the existing database, since it's read/written by a legacy VAX based system. In its simplest form, the app only needs to read one remote text file (a list of orders) which is easily handled by creating a single streamreader in a web client. In its most complicated form, a remote user could request a "summary" whereby the app has to read a lot of files and collate all the data. Needless to say this functionality is needed yesterday by an app that wasnt designed to support this

I guess this is one of these occasions where I should do a 'wet lab exercise' and see what performance I actually get.