Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Frontend=VB, backend=VFP: slow
Message
From
27/09/2000 12:43:46
 
 
To
27/09/2000 12:03:44
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00421534
Message ID:
00421575
Views:
16
>I'm being ask to help someone with a problem and I'm looking for ideas, insights and workaround :-)
>
>An application is built with VB as frontend and connects through ADO to a VFP backend.
>
>The problem is that it is very slow (up to 20 seconds in some cases)when updating the database.
>
>I have work with VFP and with VB but never with this kind of setup and, before I diving in, I would welcome your comments.
>
>Some solutions come to mind, and would like your input, or other solutions :)
>1. use of DataClass (I thought this would apply to VB/VFP apps)
>2. migrate the backend to SQLServer (although VFP backend is fast)
>3. migrate the frontend to VFP
>
>
>TIA.

Try moving the back-end to Jet (Access) and see if it's any faster.

-JT
Jeff Trockman, MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform