Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

RE: Expand / Collapse
Author
Message
Posted Friday, March 11, 2005 3:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 5:23 AM
Points: 108, Visits: 23

Its a surprise to read that!

So if, purely hypothetically, you had not that long ago gone through your entire applications 800 stored procs, ammended them all to be dbo.procname and changed every exec to include dbo. prefix and every call from asp to the same stored procs because you'd discovered it was good practice to guarantee cache hits...

You might have WASTED YOUR TIME because if there was a different case in any SP name or parameter name (*very likely*) when called from asp or another SP you would still not get as cache hit.

This is absolutely STUPID to enforce case for a cache hit and would only make sense if case was enforced when defining and calling the SPs themselves; t-sql and asp etc are all case insensitive - argh profanities!!

In my view this is definitely a flaw, a bug even.




Post #167360
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse