ASP Database efficiency

Results 1 to 3 of 3

Thread: ASP Database efficiency

  1. #1
    Join Date
    Dec 1969

    Default ASP Database efficiency

    Which is the best way:<BR><BR>To call one stored procedure from ASP, returning multiple recordsets (possibly more than 100) OR Call the stored procedure multiple times (more than 100 times) from the asp for each different input parameter...<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: ASP Database efficiency

    Just time it and see, however I would reckon calling one stored procedure would be more efficient.<BR><BR>Resolving the IDispatch interface many times is more intensive than just the once as you are going back and forth many times which is costly.<BR><BR>Havent tested this but I&#039;m pretty sure this would be the case.

  3. #3
    Join Date
    Dec 1969

    Default uh...

    I know this isn&#039;t your question but do you really need to return possibly 100 recordsets? Could you possibly return that data in one recordset w/ multiple rows?<BR><BR>Maybe not, but I&#039;d try to answer those questions before I worried about the speed of calling 100 times vs 1.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts