Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-39259

Mobile SE: Adjust SQLite Pragmas for Improved Performance

    • Minor Change
    • v4.0

      Early adopter testing and PoCs have shown that the performance of MongoDB Mobile hinders its use in some use cases. So we should look at how we can improve the performance of the underlying storage engine (which wraps sqlite).

      For example, currently the write calls are fully synchronous and we do a flush and sync on each call. The performance trade-off for that is too high for many common use cases. We should change the default for the synchronous PRAGMA to NORMAL/1, but also add a new parameter so that users have the choice.

      We should explore the available sqlite pragmas that will allow us to achieve better overall performance.

            Assignee:
            matt.lord Matt Lord (Inactive)
            Reporter:
            matt.lord Matt Lord (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: