Coffeehouse Post

Single Post Permalink

View Thread: How big are your sprocs?
  • User profile image
    Pop Catalin Sever

    Don't know how big the sproc is but it has an 870 lines(+-) select query. It joins data from around 50 tables doing multiple agregates and uses variuouse functions. It basicaly does statistics on a conected graph with tens of thousants of lines at the largest level. It also has some comments and not all lines are sql statements. No temporary tables are used in the query.