76

Re: What DB to select?

AlekseySQL wrote:

AOS (array of struct):
The size  bin - files (there is no compression): 23.3
Write time bin - files (only on HDD): 290
Read time bin - files (with HDD + SSD): 89

SOA (struct of array):

The size  bin - files (there is a compression): 6.8
Write time bin - files (only on HDD): 176
Read time bin - files (with HDD + SSD): 11.5
It is visible that the size of files decreased ~3 times, and speed of reading grew ~8 times. There was it because not all columns were read from a disk, and some have been passed with the help seekg (). I am happy with result.

I deceived all of you:
AOS (array of struct):
The size  bin - files (there is no compression): 23.3
Write time bin - files (only on HDD): 290
Read time bin - files (with HDD + SSD): 53
SOA (struct of array):
The size  bin - files (there is a compression): 6.8
Write time bin - files (only on HDD): 176
Read time bin - files (with HDD + SSD): 24
I.e. speed of reading increased even less, than the size of files was reduced. Though without the pass of unnecessary columns read time will be worse: 30  ...
I connect such insignificant magnification of speed of reading by that at me small files turned out many, in the size it is less 4 . As reading goes pages on 4  not always file size abbreviation conducts to acceleration. So it is possible in we wash a case an overhead charge for a DB cover an overhead charge connected by that I work with small files, reading to pages on 4 .