Help with Stored Procedure Execution Speed - Delphi 6

I have a stored procedure - MS SQL 2000 - that runs in less than 3 minutes
in query analyzer and returns around 13000 records. However, in my Delphi 6
application, I call the stored procedure using a TADOQuery passing the
appropriate parameters and it times out. I have been increasing the time out
setting just to see how long it would take. I currently have it set at 16
minutes and I still time out. I have tried using DisableControls on the
query because I think I read somewhere that that should help.

Has anyone else faced and solved a similar problem?

Thanks
Eric


.

Relevant Pages

  • Q: on stored procedure
    ... In a stored procedure I've a WHERE condition which asks for the following ... When I run the query, the window comes up with D_END and then with D_Start. ... Prev by Date: ...
    (microsoft.public.sqlserver.datamining)
  • Re: What is the "@" for?
    ... where you got that query from? ... I bet it was from a stored procedure, if that is so you cannot use it from ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: optional parameter in sql query
    ... I want to use the td column in the query only if @td variable is ... passed to the stored procedure. ... Thannks ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • DataSet.WriteXml
    ... I have a stored procedure with a query ... I need my xml looks like this ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Stored Procedure - Obtaining Output
    ... I would like to set up a stored procedure that does the following... ... How to I trap the output of this query! ... Wez ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)