> > >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
>
> The most used solution is a Remote Desktop, I thin, which wouldn't in principle cost you any redevelopment, but a browser based app is also popular, and there are several development tools for VFP developers: WestWind, AFP, ActiveVFP.
> -Anders
Thank you Anders, Remote Desktop is an option but it would require every user to open a remote desktop connection and we want to do this as straightforward as possible and with minimal changes for the end-user that's used to having a shortcut on the desktop to the application. There is a solution called 2X (
www.2x.com) we have been testing in our LAN and it appears to do what we want. I'll post any progress that could help someone else with a similar issue. In the meantime, feel free to comment!
Thanks,
JD