Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File locking
Message
 
To
26/07/2000 09:51:04
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00396725
Message ID:
00397444
Views:
13
>Yes I am using remote views.
I worked a contract a couple of months back. A large global enterprise system was converted from remote views to "pass thru" cursors. Stored procedures on the back end. It made a big difference. There are a lot of performance problems with remote vies. They're easy to code, but slow and unpredictable to use.

The way it worked: SQL read into local VFP cursors, which then populated VFP / AX controls. Changes made were updated or inserted back to the server as single record buffers. 86 the the RVs if you need a hot system.

T
Imagination is more important than knowledge
Previous
Reply
Map
View

Click here to load this message in the networking platform