tag:blogger.com,1999:blog-6314876008291942531.post5246186328910262991..comments2024-01-14T00:36:43.430-08:00Comments on Antonio Gulli's coding playground: Would you keep you index in internal memory or external memoryUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6314876008291942531.post-76521424227207279702011-03-09T16:34:31.173-08:002011-03-09T16:34:31.173-08:00The answer really depends on the specifics of the ...The answer really depends on the specifics of the business problem you are trying to solve, doesn't it?<br /><br />What is the user tolerance of latency in the application? Is most data access random or sequential? How much do the additional servers cost needed to use internal memory versus the benefit of reduced latency? How large is the working set and is the problem amenable to partial solutions like keeping part of the index in memory? How much is the design simplified, reliability improved, and complexity of code reduced if you add more hardware?<br /><br />Generally, I lean toward keeping as much data as possible in memory. The cost of latency is high and often underestimated, as is the cost of complexity that comes from trying to make do with too little hardware. But, the answer to this question depends on the specifics of the question, that is, the specifics of the needs of the business and application.Greg Lindenhttps://www.blogger.com/profile/09216403000599463072noreply@blogger.comtag:blogger.com,1999:blog-6314876008291942531.post-89864312185479969132011-03-08T09:07:54.091-08:002011-03-08T09:07:54.091-08:00This comment has been removed by the author.Greg Lindenhttps://www.blogger.com/profile/09216403000599463072noreply@blogger.com