The query time itself will be the same. What will take longer under COM is passing the data back to the UI.
>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?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer