Hello,
I am using the sqlite-jdbc-3.7.8-20111025.014814-1.jar , trying to set the
journaling off on my 'main' only opened db.
SQLiteConfig config = new SQLiteConfig();
config.setJournalMode(SQLiteConfig.JournalMode.OFF);
writeLog("Timestamp properties");
Properties propSqlite = config.toProperties();
When I run, I see from my properties display that the journaling is off, but
I still see a journal file being created when I run it.
{open_mode=6, journal_mode=OFF)
Does anyone have experience with turning this off thru the SqlLiteConfig
object? Any tips on usage?
The reason I'm tring this is that we keep running out of memory during the
processing of a large transaction (about 52,000 updates). I try changing cache
size and ournal size limits, but I'm not sure if it's really taking affect.
If anyone has some tips on settings for large transactions like this, please
share!
Thanks,
Doug
Doug Crites
Sr Software Engineer
doug.cri...@asg.com<mailto:doug.cri...@asg.com>
The Commons
708 Goodlette Road N
Naples, FL 34102
Tel: 239.435.2293
Fax: 239.213.3501
Toll-Free: 800.932.5536 USA Only
www.asg.com<http://www.asg.com/>
ASG-CloudFactory - The Single Solution to Build, Deploy & Manage your Cloud
Environments
Click here for more information on the
ASG-CloudFactory<http://www.asg.com/cloudfactory>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
