Yes, that's true. VPN is like actually being in the office but over a slower link. Terminal server is like running the program on your machine in the office and viewing it via video camera and remote mouse. You never run the program you just get the results. But it's a LOT more money in general and I don't think it's really the way to go. My preference would be for a true client/server architecture with a SQL backend. This would be sort of a hybrid approach. Let the server churn on the SQL queries itself and return the results. Let your local machine actually run the program and view the results.
So, Evo could still work well if the thing was designed for it. SQL tends to take more time to parse but tends to also deal with less data. I guarantee that GL-E could be implemented in such a way that it need not send every record to the client. The DB server could easily sum up the data for previous records all by itself. Or, running balances on a day to day basis could be stored. Each would need 365 entries for each year. The entry would be a float probably so 4 bytes. Thats 1460 bytes per GL account per year. That's nothing. Things like that really speed the program up.
I suppose I just live in fantasy land. It's great here, I'll say hi to the mermaids for all of you...
Quote from kevind on 04/13/07 at 09:39:44:VPN and Terminal Services are two completely different animals.
VPN:
Server (with data) ------ Network ------- Client PC (execute programs)
Programs execute on client PC (all applications must pass through the network)
Data that programs request must pass through the network.
(Remember that last GL-E you ran on all accounts for 1 day?
Every record in that GL transaction file was read. )
Total data passing over the network is a huge amount not to mention the VPN overhead.
Terminal Services:
Server (with data and executes programs) -------- Network ------- Client PC (renders GDI)
Programs execute on the Server. Only GDI (graphical device interface) API commands pass through
the network and get rendered by all the horsepower of the client PC.
All data gets requested and used internal to the server. No business data passes through the network.
Total data passing over the network is limited to the GDI API.
In terms of bytes per second, there is a significant difference.