Hi Craig

>The query time itself will be the same. What will take longer under COM is passing the data back to the UI.

I understand about the data flowing back, but does it not also take time to trigger a function in the DLL, passing parameters etc. Isn't end-to-end testing required to see what pieces to disregard?

>
>>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?