I have written an application in ASP (with ADO) and an SQL server DB, but the performance is not good. I did run a trace in the SQL-profiler and the first 840 lines are covered with executions of the sp_cursorfetch, sp_cursoroption and sp_cursor stored procedures.
I don't know what causes these problems and I don't know how to solve them. Can someone help me on this?
PS: I use sometimes filters on recordsets in my ASP code. Is this okay?