Cache עבור שאילתות עדכון

28 באוקטובר 2009

English: How to Caching updates to minimize I/O cost of these operations, for example – counting views on forum message. the solution I provided is to create a table/static variable that holds updates "log" and update the main heavy table with timer. For example – for counting forum message views, I add row to some log table (that I can store in somewhere else, like RAM drive or MySQL Memory table) with timer updates main table and empty the log table for fast access later. הבעיה: שרת SQL Server 2005 של מערכת Web. ניתוח...
אין תגובות