Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pass through vs Remote Views
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00154123
Message ID:
00154301
Views:
24
Thanks for the reply! We have an app that is using SPT and it still seems slow. I suspect it is the network setup. Do you have any recommendations on how to speed up the app?

>We have, and SPT wins every time. In fact we're currently in the process of converting a massive data import application from using remote views to SPT for performance reasons. Maintaining 165 remote views is not fun!
>
>SPT has much less overhead, and you don't have to deal with the database container. Of course, this means you have to take care of all the housekeeping yourself in code, so if time is a factor, remote views will get you up and running faster. But if you have the time, I'd recommend the pass-through method.
>
>Just my 2¢!
>
>>Has anyone done any comparisons on SQL pass through and remote view as to which is better gives you better performance?
DLC
"Use the Right Tool for the Job!"
davidandcynthia@email.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform