Hi<BR> I am using ASP as friont end.. In the ASP i call SQL stored procs.. The stored proc has to process certain no of record.. after they are processed The ASP next displays all the records.<BR>THe problem i face is when no of records are large. The stored proc is executed.. then control is back to ASP.. but at this time.. DLLHost.exe takes upto 99% CPU.. whole system bcomes slow.. SQL trace shows "ghost" queries.. and then after some time all of a sudden the rest of ASP is executed.. This prob is not faced when no of records are small.. WHy does DLLhost take so much of CPU and system get stuck there? i am using command object to call stored procs..