>>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.
>
>If the back-end is already VFP and is not going to be changed, then moving front-end to VFP makes most sense, IMHO.
Indead, the backend is VFP.
And SQL Server is discussed but since the table where the updates are causing problems have about 300,000 records then VFP should not be the problem. Am I right?
Ben Rail
Business Solutions
LOGI.design