Tim’s Weblog Tim's Weblog
Tim Strehle’s links and thoughts on Web apps, managing software development and Digital Asset Management, since 2002.

Caching at the SQL-Client Layer

Chris DiBona has a nice idea on SQL result caching: "First thing, before any actual real queries happen, the page construction logic should query the tracking table to get a list of tables that have become dirty since the last time a page was constructed, this can commonly become the only query that a page might see. In the event that a list of "dirtied" tables has been returned, the routine should remove the cached tables from whatever storage you're using."

Mon, 20 Oct 2003 06:41:04 +0000