The former. I think most sane serious dbs cache and manipulate recently-used data in memory (in addition to the logical log).
Bad idea or no, it's what they do - performance gains are large. There is an ersatz logical log in the form of application logs, and these have been used to piece together transactional information before.
Comments
The former. I think most sane serious dbs cache and manipulate recently-used data in memory (in addition to the logical log).
Bad idea or no, it's what they do - performance gains are large. There is an ersatz logical log in the form of application logs, and these have been used to piece together transactional information before.