Post reply

What is the best solution : a long stored procedure or several sql queries????

  • June 17, 2005 at 3:40 am

    #109549

    Hi there!!

    I'm developing a Web application in ASP that uses several MS SQL databases.

    I have to extract information from those different databases. So I wonder if I should do it in a single stored procedure that will last about 10 minutes or in different sql queries from my ASP code??

    Please, let know your opinions!!!

    Thanks in advance!

    Sansan

     

  • June 17, 2005 at 5:22 am

    #566364

    How long do the individual queries take?  What is the expected run time agreement for the customer?  What happens if 1 query fails but all the others work?



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

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

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