Thanks Mariano, So my suspicion was right and I was managing improperly the SQLite connections and not making a explicit closing of them. I could improve the code, but I can't find the package which provides SQLiteConnection (on pharo 4 it was NBSQLite). How can I find/install it? Cheers, Offray On 12/04/16 20:03, Mariano Martinez Peck wrote:
What looks not related to memory issue is that the crash seems to happen in #close:
Smalltalk stack dump: 0xffc655d4 SqliteLibrary>close: 0x9726108: a(n) SqliteLibrary 0xffc655f4 SQLiteConnection>close 0xc672d08: a(n) SQLiteConnection 0xffc65610 SQLiteConnection>finalize 0xc672d08: a(n) SQLiteConnection 0xffc65630 WeakFinalizerItem>finalizeValues 0xc692b60: a(n) WeakFinalizerItem
The idea is obvious...and I did exactly the same for SqueakDBX (now OpenDBXDriver / Garage).... register the connections into the WeakRegistry so that they are automatically closed without having the user to manually do so. I remember I had a case where the user WAS already doing an explicit close and I would crash very much like this case when I was trying to close a connection that was already closed.
I don't have Sqlite library handy, but could it be something similar?
On Tue, Apr 12, 2016 at 9:49 PM, Offray Vladimir Luna Cárdenas <offray.luna@mutabit.com <mailto:offray.luna@mutabit.com>> wrote:
Hi,
On 12/04/16 16:51, Stephan Eggermont wrote:
On 12/04/16 22:44, Offray Vladimir Luna Cárdenas wrote:
I'm working with visualizations a external dataset which contains 270k records. So the best strategy seems to bridge pharo with SQLite to keep requirements low while using Roassal to visualize aggregated information that is obtained from querying the database.
It won't fit in image?
I tried with RTTabTable and NeoCVS but they can not load the data. I made a test drawing 150k points and the image starts to lag and trying to query the data becomes inefficient compared to query the data on SQLite. For the moment I'll export the query results to CVS, but I'll hope to have the SQLite bridge working soon.
Offray
-- Mariano http://marianopeck.wordpress.com