litefs icon indicating copy to clipboard operation
litefs copied to clipboard

Mmap the underlying file

Open darthShadow opened this issue 3 years ago • 3 comments

Would it be possible to open the underlying database file with mmap for better performance or would it not be very useful since all queries need to pass through the FUSE layer anyway, which would be the bigger bottleneck?

darthShadow avatar Aug 12 '22 15:08 darthShadow

Yeah, that's definitely a possibility. mmap() can help for databases that are smaller than memory but it can have performance issues as Go will stall if the page needs to be read from disk. I'm currently focused on correctness but it's something I'll try once I get to performance improvement.

benbjohnson avatar Aug 12 '22 16:08 benbjohnson

Perfect, thanks.

darthShadow avatar Aug 12 '22 16:08 darthShadow

here be dragons: Are You Sure You Want to Use MMAP in Your Database Management System? youtube | mirror | review

ignoramous avatar Sep 24 '22 15:09 ignoramous