I have a query that I set up as cursor in a stored procedure that takes 30+ minutes to return results. If I do not use a SP I get the same result set back in less than a minute. The SP starts returning data quickly but takes the 30+ minutes to finish.
Does anyone know why I may be having problems?
I am using a native connection. I was going to try it with a CR ODBC driver but when I do it does not list stored procedures to choose from. That is another question to be answered :).
I looked at this KB document, 1181947, but is seems to refer to an old Business Objects link that does not work.
Please help.