> What's SUPERSERVER_V2 in the code?
My review of the code (back in 2003, see attached) found the following:
- Asynchronous File I/O
- PreFetch Data Pages (i.e. statement is a natural scan so read-ahead in the
file...)
- Defer Header Page Write (i.e. reduce the number of times that the header page
is written to disk)
> Will it be used some day?
I think there is some good things, though need to be tested.
In general, however, I'm not sure that those features (all in the disk IO area)
have been outpaced by technological changes -- namely,
- Storage controllers with large RAM cache (2 or 4GB or in some cases 64GB)
- Storage controllers with large SSD supported read caches
- SSDs (10-15x IOPs of HDDs)
- PCIe SSDs (5-10x IOPs of SSDs)
- Cross-point/Optane/NV-DIMM storage (5-10x IOPs of PCIe SSDs)
Sean
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
