Farouk,
>I have narrow down to the calling of the VFP COM which causing the slowness. I have even uninstall SP2 back to SP1 but all these does not affect the concerned server. Running out of ideas. Any more tips?
I don't have any specific tips for improving performance on calling a VFP COM object. You may want to check if it's the call to the object that's slow or the action the object is performing.
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