[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: |
|
||||||||||||||||||||||||
| 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: (cherry picked from commit 0cfc32589d5f6436e83d6d0d290849cf3798cbae) |
| Comment by Githook User [ 15/Mar/19 ] |
|
Author: {'name': 'Matt Lord', 'username': 'mattlord', 'email': 'mattalord@gmail.com'}Message: |