Re:12,000 Requests per second with Nginx, PHP and Memcached
by jonah on Tuesday February 15, 2011 @01:33AM
(#2220386)
I've been thinking along similar lines for my project and the issue i'm running into conceptually is tracking WHICH cache records to invalidate upon POST. Say an HTML list, an HTML detail page, and a full composite object all contain references to the particular item you updated. Single items - the detail page and object are fairly easy to know about, but what about a list view and a grid view that also contain that item. What are your thoughts?
[ Parent
| on HN ]
Re:12,000 Requests per second with Nginx, PHP and Memcached
by roel_v on Tuesday February 15, 2011 @05:14AM
(#2220763)
A dependency graph between database tables and pages, no? How to define 'page' depends on the rest of the application, I guess in most frameworks it would be 'module' + 'action'.
Re:12,000 Requests per second with Nginx, PHP and Memcached
by jacques_chester on Tuesday February 15, 2011 @02:10AM
(#2220445)
My thoughts were to borrow a page from wikis and make links between documents a part of the model.
For actual documents (blog posts, comments etc) I'd place them on disk. Metadata, including links between pages, would be in the database.
With Postgres triggers + NOTIFY you can cause invalidation based on INSERTs and UPDATEs.