Hi, I use sqlite as a persistence layer for my application (my application has two parts, java and C++).
>From the java side, I re-create Objects from each row of a table. At the begining, I performed a standard SQL request, and walk trough the ResultSet to build my Objects. Then, to increase performance, I created a custom function to avoid walking trough the ResultSet: This custom function creates directly an Object for each row of the table. However, in these 2 configuration, if the table is big (e.g. ~200000 rows from a table), I obtain the following error: "java.lang.OutOfMemoryError: java heap space" I saw with TPTP that the memory is filled by the class "org.sqlite.SQLite" with a lot of array of int. I guess these arrays are a memory image of the database, isn't it ? How to avoid such error ? Many thanks, Xavier --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLiteJDBC" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlitejdbc?hl=en -~----------~----~----~----~------~----~------~--~---
