Large sqlite table, out of memory
I Have a large sqlite DB (about 380k records, 2.5GB) that i need to report.
I have recompiled sqliteconnection and it works "well".
Trying to prepare the report, the memory growth fast and out of memory occurs.
Any idea?
Regards
I have recompiled sqliteconnection and it works "well".
Trying to prepare the report, the memory growth fast and out of memory occurs.
Any idea?
Regards
Comments
maybe you can split the report into smaller chunks? ie having record 1-50.000 then 50.501 - 100.000 .... and so on. I know that this may not be what you were looking for, but maybe it helps.
Best Regards,
Keeper