>I have LAN based application that needs to be scaled to wide area access.
>My first thought was to switch the backend to SQL7 to minimize the amount
>data carried over the wire to these locations and to take advantage of the
>power of moving functionality into stored procedures. A traditional Client
>Server application.
>
>If I were to move my app to the internet instead, would I have better
>performance? Instead of moving the results of SQL queries down the wire to
>the client front ends (VFP), I would be sending HTML formatted data back to
>a browser. Also, the datasource (VFP or SQL7) will be located on the same
>box as the web server. What setup performs better and why?
>
>Thanx, I appreciate your opinons!
>Charlie

Charlie,

it's really hard to give you a generic answer, it's alway the same when it's about performance. The performance depends on too many variables, like:

- does your WAN have dedicated lines or not.
- what kind of data do you want to transfer.
- which frequency
- ...

Also don't forget the security issues in the internet infrastructure. Yes you may use the encryption features of the https protocol, but it's slower then the normal http.

Hope this helps.