Specific SQL Procedures

Posted on 2009-12-29
Last Modified: 2012-05-08
I'm designing a new high volume database from scratch and was planning to have very specific SQL stored procedures.  I want lean logic that a particular application (ASPX) section or two will own.  The idea is to get away from these jack-of-all-trades procedures.  How will using many smaller procs affect performance? (We have a large number of concurrent users...250+ per minute connecting)
Question by:Phil5780
    LVL 60

    Accepted Solution

    Well, depends on how they are written.  There really isn't going to be too much of a performance difference between a well written longer proc vs well written shorter procs.  I prefer the shorter procs because its easier to modularize logic...

    Its a good idea to try to minimize the amount of times you have to hit the, you could have one procedure that calls lots of other procedures...that way you don't have to make many proc calls that travel over the network to hit the db.  Does that make sense?

    Author Comment

    Great, thats what I had been thinking to do.  Thanks for the input:)

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
         When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now