General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
Hi, Sergey
Then you know any advantage in using VFP OLE DB and not USE direct?
I am changing my application to work with VFP OLE DB :(
>You're mistaken. All the processing is done on a workstation because VFP OLE DB provider runs on the workstation.
>
>>I use OLE DB to develop client-server application.
>>
>>When use this options
>>
>>Use Data\Client
>>or
>>Select * from Data\Client into cursor curClient
>>or
>>Open tables by DataEnvironment
>>
>>The table are transfered through the network and in the client machine the filter is executed.
>>This application that I use OLE DB are about 400 MB of DBF tables and transfer it on the network decrease the performance of the application becouse allocates many network resources.
>>
>>So, the solution is don't transfer the DBF tables through the network. With OLE DB the filter is executed on the server and only the date needed is transfered. It don't allocate manu network resources and the application get better performance.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only