Response from Thomas, answering my question:
I guess I would use 'cached' tables (meaning the data is persisted,
and the indexes are persisted), just to avoid out-of-memory in all
cases. If it turns out to be a performance problem (which I don't
think it will) it could still be changed later on.
should get replaced with