[sqlite] Perl DBI/Sqlite Attach too much memory

on how to reduce the memory consumption when using attach? Thank You -- -- John Lynch (217) 953-0557 johntly...@gmail.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Attach databases using tons of memory (DBI Perl)

on how to reduce the memory consumption when using attach? Thank You -- -- John Lynch (217) 953-0557 johntly...@gmail.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Attach databases using tons of memory (DBI Perl)

width table ( a product of all 3 attached tables, flattened into 1 table) and run it with the same script I have no memory issues. I am hoping there is something I am missing with caching and attach. Maybe a pragma or something? 2009/9/25 P Kishor > On Thu, Sep 24, 2009 at 3:30 PM, John Ly

Re: [sqlite] Attach databases using tons of memory (DBI Perl)

gt; sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- -- John Lynch (217) 953-0557 johntly...@gmail.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Attach databases using tons of memory (DBI Perl)

I will try what you have mentioned below. I am 99% sure it isnt the perl script, since it doesn't have the same behavior without attaches. I will let you know what happens. Thank You 2009/9/25 D. Richard Hipp > > On Sep 25, 2009, at 11:02 AM, John Lynch wrote: > > > pag