Major memory leak

[aliakhtar]

Details: https://stackoverflow.com/questions/56883748/memory-leak-with-jdbc-sqlite

[guangwei-qiao]

I also found physical memory leak issue after close sqlite connection, how to insure release physical memory?

[aliakhtar]

@guangwei-qiao I moved from Sqlite to CQEngine and it saved me from a lot of headaches & issues & improved performance a lot. I'd suggest doing the same if you have a primarily read-based workflow.

[guangwei-qiao]

@guangwei-qiao I moved from Sqlite to CQEngine and it saved me from a lot of headaches & issues & improved performance a lot. I'd suggest doing the same if you have a primarily read-based workflow.

Excellent suggestion! however, my scenario is to save memory, CQEngine is not very suitable!

[aliakhtar]

@guangwei-qiao For saving memory I'd suggest trying Eclipse J9 JDK if you're using Oracle / Hotspot: https://adoptopenjdk.net/

I think CQEngine can also be used with filed based / persistent indexes in which case it won't load the data up front in memory.

[guangwei-qiao]

@guangwei-qiao For saving memory I'd suggest trying Eclipse J9 JDK if you're using Oracle / Hotspot: https://adoptopenjdk.net/

I think CQEngine can also be used with filed based / persistent indexes in which case it won't load the data up front in memory.

thanks a lot, will try it.

[A248]

#528 may have fixed your issue

[gotson]

Is this still happening on the latest version?