Comments (10)
When do you close your Cursors or are you relying on the finalizer to close them?
from sqlite-android.
I always read the data then explicitly close the cursor asap. This is possibly a problem in SQLite Android Binding. But I have no time to get a minimal test case now....
from sqlite-android.
Please try the 3.12.1-1 version
from sqlite-android.
@npurushe OOM is gone
from sqlite-android.
Great! thanks for reporting
from sqlite-android.
Hello. I can still reproduce this in certain phones...Galaxy Note3, Android 5.0
from sqlite-android.
Do you get any warnings in your adb log from the SQLite
tag (or anything with the message A resource was acquired at attached stack trace but never released
) ? Is it only on Android 5.0?
from sqlite-android.
@npurushe no, there is none. but the native dirty memory will increase to around 60 mb. I can only reproduce it in one Android 5.0 phone, a Galaxy Note 3, with a Samsung custom Android 5.0. This is very wired to me, as the whole sqlite subsystem is in this project and shouldn't be platform dependent. Or it is not a real memory leak, but maybe it is because on that phone the memory constraint is different and this project doesn't meet the constraint but the system one meet.
from sqlite-android.
@npurushe just read your README.md about the read performance. So this project allocate memory differently compared to "SQLite Android Binding" project and Android embedded SQLite? Please reopen this issue because I am sure it still exists..
OK. after read the AOSP code and your code, seems the issue is AOSP create memory in ashmem but your code create memory in app heap... So I will see if I can make memory allocation smaller
from sqlite-android.
Yes that is the primary difference. I looked at the CursorWindow allocations and everything that was allocated was freed in all tests, so are you sure there is an issue there? How many cursors do you have open while running your program?
from sqlite-android.
Related Issues (20)
- How to quickly add a custom tokenizer?
- How can I integrate SqlCipher while using `RequerySQLiteOpenHelperFactory` with Room HOT 2
- Version 3.37.2 not available HOT 4
- Version 3.37.2 and 3.38.4 unavailable on Jitpack HOT 3
- Add integeration to studio app inspection
- Bundling sqlite can cause data corruption on Android N and later HOT 7
- Performance on "big" data compared to native Android HOT 3
- Cannot use Android Studio's Database Inspector HOT 1
- Could not HEAD 'https://jitpack.io/com/github/requery/sqlite-android/3.39.2/sqlite-android-3.39.2.aar'. Received status code 521 from server: HOT 1
- Missing proguard rule leads to crash HOT 1
- SQLiteProgram wrong getSqlStatementType assumption breaks concurrent reading in SQLite WAL mode HOT 1
- 3.40.1 jitpack build fail HOT 1
- License information removed from artifacts HOT 2
- httpmysql injection
- Enable geopoly interface (module)
- proguard error HOT 3
- Open to a PR to support sqlite3_update_hook, sqlite3_commit_hook, sqlite3_rollback_hook? HOT 2
- several feature requests to this library HOT 1
- Kotlin Multiplatform Support (KMP) HOT 1
- Use of compile option -latomic gives warning about incorrect builds HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlite-android.