WarpSQL Server, an open source OLAP focused distribution of the world's most popular open source database bundled with OLAP performance related plugins such as the WARP storage engine..
Right now the deleted rid bitmap is read in in 8 byte chunks. That is a lot of fread() calls (even though the OS should buffer the reads). A table with 64 million rows only takes 8MB of space to store the bitmap entirely in ram, so it makes sense to read the whole thing in and just point ->bits to the proper offset in the buffer.
Right now the deleted rid bitmap is read in in 8 byte chunks. That is a lot of fread() calls (even though the OS should buffer the reads). A table with 64 million rows only takes 8MB of space to store the bitmap entirely in ram, so it makes sense to read the whole thing in and just point ->bits to the proper offset in the buffer.