Rethinking Your Design

  • Comments posted to this topic are about the item Rethinking Your Design

  • Steve, it sounds like a good time for an in-depth treatment of SQL Server's in-memory capabilities ;^)

  • 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.

  • 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.

  • 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"

  • 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