Farouk,
>I done the above and running my source thru the VS.Net against the server SQLServer, performance is OK. When I deployed the new setup into the server, to open 1 page it is very slow. What could be the cause?
Is debugging turned off in your application?
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com