February 9, 2013 at 12:34 pm
Comments posted to this topic are about the item Rethinking Your Design
February 9, 2013 at 4:55 pm
Steve, it sounds like a good time for an in-depth treatment of SQL Server's in-memory capabilities ;^)
February 10, 2013 at 4:29 pm
Caching is also the type of solution I've found many developers enjoy implementing
That may be true, but it's also one they also fail to get right 90% of the time. Done incorrectly, it leaves apps with strange intermittent bugs, consistency errors, confusing "wait - didn't I just change that?" moments for the users (especially on a web farm) and performance bottlenecks when restarting a server.
It may be fun, but it's hard to do well.
February 11, 2013 at 8:17 am
It is important to remember that Windows Server and SQL Server provide good caching behavior right out of the box. When designing caching functionality, take care not to interfere with or duplicate what is already occurring.
February 11, 2013 at 10:28 am
GeorgeCopeland (2/11/2013)
It is important to remember that Windows Server and SQL Server provide good caching behavior right out of the box. When designing caching functionality, take care not to interfere with or duplicate what is already occurring.
Good point George. if one does not know exactly what they are doing in this area they can easily make things worse. 😀
"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
February 11, 2013 at 10:36 am
LoztInSpace (2/10/2013)
Caching is also the type of solution I've found many developers enjoy implementing
That may be true, but it's also one they also fail to get right 90% of the time. Done incorrectly, it leaves apps with strange intermittent bugs, consistency errors, confusing "wait - didn't I just change that?" moments for the users (especially on a web farm) and performance bottlenecks when restarting a server.
It may be fun, but it's hard to do well.
Very true, and I'd like to see more reference applications and information on how to do this well.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply