Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Length of the SP name matter?
Message
From
30/03/2015 10:11:53
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01617396
Message ID:
01617398
Views:
32
>Hi,
>
>I am refactoring all stored procedures used by my application. Different stored procedures are used by different applications (some by VFP, some by one ASP.NET app and some by another ASP.NET app). So I want to implement the naming convention such that the first part of the stored procedure will be the name of the application. Example of names:
>
>MyVfpApplicatio_table_name_add_new
>MyAspNetApp1_table_name_proced_name
>
>
>So some names will be quite long, up to 40 characters. Will it slow down the execution?

No. Transferring and processing the longer names are immaterial compared to the work actually done in the SP.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform