I have a stored procedure with parameters in SQL Server 2000 database. When I execute it in Enterprise Manager, it takes less than 1 second to return rows.
When I use it in VB 6 code to populate ADODB.Recordset, it takes more than 30 seconds on this particular line:

Set rsOrders = cndTemp.Execute

I'm wondering why is it like that, and how can I make it work with the same
or at least similar speed in VB?

Thank you