Query mystery ??

  • We have a web page that hits a series of stored procedures and produces results on an ASP Page.

    The page is very slow when loading the data, but is very front end light. Very few records are returned to the page.

    We run Profiler, capture the exact procs & params being sent to SQL, gather them and run them in QA. Bamm! Lightning fast.

    We have checked for network bottlenecks and nothing.

    Any ideas greatly appreciated!!

    -Thanks

  • I think we got it.

    We threw With recompile in the proc and bamm, back to normal.

    Question:

    Why was QA acting differently?

    Why was is recompile needed?

    Thanks

  • Check your ,OLE-DB Service ,ADO is accessing the SQL Server through a totally diffrent set of libs , You might have cahanged some important index in a table ,wich some times need a recompile ,see sp_recompile

    Regards john

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply