Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Normal querys VS stored Procedures
- Thread starter Ginka
- Start date
Read this debate:
The answer ultimately comes down to what your current development practices are like, what your performance needs are, and the level of additional effort you're willing to go to to gain the performance you want.
Chip H.
____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
The answer ultimately comes down to what your current development practices are like, what your performance needs are, and the level of additional effort you're willing to go to to gain the performance you want.
Chip H.
____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
The best practice is to have your code centralized and separate according to use. Separate SQL with app code. You get better performance output from both your app server and database server since each will be used natively to their level. You gain scalability by doing so.
I think conraba is saying that your app should be properly layered, with database code not intermixed with user interface code.
correct?
Chip H.
____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
correct?
Chip H.
____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
- Status
Similar threads
- Locked
- Question