[SERVER-39259] Mobile SE: Adjust SQLite Pragmas for Improved Performance Created: 29/Jan/19  Updated: 29/Oct/23  Resolved: 15/Mar/19

Status: Closed
Project: Core Server
Component/s: Mobile, Storage
Affects Version/s: None
Fix Version/s: 4.0.7, 4.1.10

Type: Improvement Priority: Major - P3
Reporter: Matt Lord (Inactive) Assignee: Matt Lord (Inactive)
Resolution: Fixed Votes: 0
Labels: mobile, storage-engines, sync
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
is depended on by SERVER-32709 Mobile SE: Index creation takes a lon... Closed
Related
related to SERVER-40124 Mobile SE: Make All SQLite Pragmas Co... Closed
is related to SERVER-33651 Mobile SE: Use full synchronous mode ... Closed
Backwards Compatibility: Minor Change
Backport Requested:
v4.0
Participants:

 Description   

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.



 Comments   
Comment by Eric Milkie [ 03/Apr/19 ]

Note that the above commit is now understood to have had no effect, due to a bug.

Comment by Githook User [ 16/Mar/19 ]

Author:

{'name': 'Matt Lord', 'username': 'mattlord', 'email': 'mattalord@gmail.com'}

Message: SERVER-39259 Mobile SE: Adjust SQLite Pragmas for Improved Performance

(cherry picked from commit 0cfc32589d5f6436e83d6d0d290849cf3798cbae)
Branch: v4.0
https://github.com/mongodb/mongo/commit/21d8ae0a1666446984886293b65069784eb117bd

Comment by Githook User [ 15/Mar/19 ]

Author:

{'name': 'Matt Lord', 'username': 'mattlord', 'email': 'mattalord@gmail.com'}

Message: SERVER-39259 Mobile SE: Adjust SQLite Pragmas for Improved Performance
Branch: master
https://github.com/mongodb/mongo/commit/0cfc32589d5f6436e83d6d0d290849cf3798cbae

Generated at Thu Feb 08 04:51:31 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.