Results 1 to 6 of 6

Thread: SQLite Now Faster With Memory Mapped I/O

  1. #1
    Join Date
    Jan 2007
    Posts
    15,638

    Default SQLite Now Faster With Memory Mapped I/O

    Phoronix: SQLite Now Faster With Memory Mapped I/O

    SQLite 3.7.17 was released yesterday. What makes this new release of the popular lightweight SQL database software noteworthy is that it introduces support for memory-mapped I/O...

    http://www.phoronix.com/vr.php?view=MTM3NjQ

  2. #2
    Join Date
    Sep 2009
    Posts
    60

    Default Good job

    As someone who has this as my only option for an embedded system, I can say this library (though not perfect) does very well. My biggest complaint was performance during non-obvious queries, which is now better. Its ability to bring together many databases was very handy, though custom functions were painful if you had to multi-thread.

  3. #3
    Join Date
    Apr 2011
    Location
    Sofia, Bulgaria
    Posts
    82

    Default What about windows?

    I wonder if the MMIO support is available on Windows. The paged linked in the article says:

    3. The operating system must have a unified buffer cache in order for the memory-mapped I/O extension to work correctly, especially in situations where two processes are accessing the same database file and one process is using memory-mapped I/O while the other is not. Not all operating systems have a unified buffer cache. In some operating systems that claim to have a unified buffer cache, the implementation is buggy and can lead to corrupt databases.

    But doesn't list the compatible OSes.

  4. #4
    Join Date
    Sep 2007
    Location
    Connecticut,USA
    Posts
    983

    Default

    Quote Originally Posted by kobblestown View Post
    I wonder if the MMIO support is available on Windows. The paged linked in the article says:

    3. The operating system must have a unified buffer cache in order for the memory-mapped I/O extension to work correctly, especially in situations where two processes are accessing the same database file and one process is using memory-mapped I/O while the other is not. Not all operating systems have a unified buffer cache. In some operating systems that claim to have a unified buffer cache, the implementation is buggy and can lead to corrupt databases.

    But doesn't list the compatible OSes.
    Windows XP to 7 should have usable MMIO support

  5. #5
    Join Date
    Jan 2008
    Posts
    195

    Default

    Y'all can thank me later for kicking their butts into adding the MMIO code. Don't expect miracles, SQLite's read performance is dominated by its SQL parser, not by the actual I/O. This may noticeably improve write speed but not much impact on read speed.

    I first raised the topic in September 2011
    http://sqlite.org:8080/cgi-bin/mailm...er/001333.html

    They started playing with it in November 2011
    http://sqlite.org:8080/cgi-bin/mailm...er/001380.html

    It's taken them quite some time to get something workable out of it.
    http://sqlite.org:8080/cgi-bin/mailm...ly/001787.html
    http://sqlite.org:8080/cgi-bin/mailm...ly/001720.html
    http://sqlite.org:8080/cgi-bin/mailm...er/001809.html

    (Sorry, their mailing list archives are only accessible to subscribers; you must be a subscriber to read the above links.)

  6. #6
    Join Date
    Jan 2013
    Posts
    12

    Default

    Good news for Firefox?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •