Post
Topic
Board Development & Technical Discussion
Merits 1 from 1 user
Re: What DB do you use at your end?
by
CIYAM
on 27/11/2016, 05:20:01 UTC
⭐ Merited by ETFbitcoin (1)
Correct me if I misunderstood something, but would not that require a MUCH bigger size of HDD?

As deletion (and in Bitcoin rollbacks) are infrequent operations it wouldn't practically be as significant an increase as you are imagining (but it would use more space for the translation log).

In addition, the log writing and reading speed would significantly increase that would result in slower DBs, would not it? At large DBs, speed is essential because some queries could take up to 20 or more minutes even without the mentioned idea.

Normal RDBMS "queries" do not involve the log at all so it would not have any speed effect upon read operations (it would only slow down "delete" operations).