Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
On the Task Maneger, analyzing the NetWork tab
- when using OLE DB the graphic is low
- when using USE the graphic is high
The diference are reflected on the application
I test it, and then changing the application.
I don know how OLE DB work, but this diference I test.
>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement