Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oana4
Starting Member
3 Posts |
 Posted - 2004-12-02 : 16:55:16
|
| Hi,I am not an expert on SQL Server but I want to know for a good performance how many LINES a procedure can have ( I saw procedure with 1000-1500 lines. it is possible something like this? In standard programming I don't think that is accepted something like this)?( it is used here different command from a simple select to complex query with functions).Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-02 : 16:55:42
|
| It just depends on what it is doing.Tara |
 |
|
|
dsdeming
479 Posts |
Posted - 2004-12-03 : 08:24:40
|
| Procedures that are doing heavy processing may get very long. Also keep in mind that the number of lines in a stored procedure is deceptive, since heavily formatted SQL tends to eat up lines. I recently wrote a complex insert statements that ran to 300 lines, but it was still one command and could have been written as a single line.Dennis |
|
|
|
|
|
|
Performance stored procedure