3 ms·
Recovery on the system restart is going at the speed of hard disk.
by nikita 14y ago
Recovery on the system restart is going at the speed of hard disk.
- chris_wot 14y agoCan you pin how much data from a table can be placed into memory, or does the whole table need to be placed in memory? I can see settings that limit the transaction log memory usage, but no way of reducing the actual amount of data in-memory.
- nikita 14y agoThe whole table has to fit in memory. RAM is getting very cheap, you can buy 1Tb for 12K today.
- suking 14y agoLoL - this whole product is like a joke... Your solution to having to fit the whole db into RAM is to buy more RAM... OK!
- tintor 14y agoRecovery on the system restart is going at the "sequential scan" speed of hard disk.
- nl 14y agoThe "sequential scan" speed of a generic SSD is pretty good. It's even better on something like FusionIO.
- genwin 14y agoBut for anyone who is renting the server, it's $$$$ monthly for a fraction of that.