>One of our clients uses our VFP application with sql server 2000 in a >distributed environment. They currently have 10 offices nationwide. This >architecture has worked for them for many years but we are now thinking about >centralizing the application in a single Datacenter and use Oracle 11g as >back-end. Our application currently works against Oracle 11G so migration is >not an issue, our primary concern in all this is the performance of our >application in a centralized architecture. Here is where I would appreciate >your input. What can I do to optimize performance of our application (besides >query optimization) in this new environment? Ive read about application >streaming (XenAPP, Xenocode, AppStream..) it seems very intersting but Im not >sure if they can be used for complex and big application, has any of you used >this? Would you recommend deploying the application in every office and just >centralizing the database or having the application and the database only in >the datacenter? Any personal experiences you can share about centralized >environments is very much welcome.
>Regards,
>JD

Anybody got any ideas? Maybe someone out there does not know about the exact issue in question but has a worked with a centralized vfp9 application against an Oracle or SQl Server back-end or any other DMBS for that matter. What about changing from a distributed to a centralized environment? Any input would be appreciated.

Thanks in advance,
JD