Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
COM/DCOM et OLE Automation
>You're right. The COM component and the EXE cannot see the same cursors. Options are ADO, XML, or a string. I prefer XML as it is easy to move between XML and a cursor.
Good. Now speculation: If a system was built with VFP cursors in our "simulated" / not physically separate COM ntier approaches, they will be faster also?
Has anyone done any benchmarking of a query of differing complexities from SQL via COM and via VFP Cursors?
>
>>Hi all
>>
>>I remember some discussion of a COM "boundary layer". I'm looking for some confirmation.
>>
>>If a VFP app accesses SQL Server and the VFP app uses a middle tier that is not compiled as a DLL, that app can access the cursors directly.
>>
>>However with COM, the data would have to be passed from the COM object to the VFP app, probably with XML or something else. Don't tell me this is a negligible performance hit, just confirm that it exists, please.
>>
>>Thanks
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