>Someone over here has heard that Foxpro doesn't do well on a WAN (I believe that it's super-slow is the main problem). What they heard is that it has something to do with the way that it sends out records. Can anyone shed any light on this so that maybe I could do further research and/or find her a definitive answer? Thanks!
---
Denise -
the definite answer is:..... it depends!!!
I've done many apps that are sling data back and forth across a WAN - frame relay links between 64K and 128K - and the performance is wonderful -
but the link is ONLY used to sling data and send out program updates.

If you have a remote workstation that invokes a program residing on a server - then of course the performance will be abysmal.

If forms are requiring an entire table from a database to load before the form is viewed - then of course the performance will be abysmal.

You can set up odbc and use sql-pass through relatively well - and NOT use the native database/table scheme with vfp, but instead design views that are populated only after a query value has been returned....

----
If someone is running the app on a workstation, with the executable and the data on the server - then the results will be abysmal.

Is odbc, remote views, and sql-pass-through client server ? Depends on which camp you send your dues to - but hey - it works most of the time at relatively slow link speeds - with blazingly fast results.

There are optimization techniques you have to go through, before, during and after the database design..

Hoping this finds you well, and well rested.. [Bill]