[sqlite] set journal off working witth SQLiteConfig?

2013-03-14 Thread Doug Crites 

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.commailto: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.comhttp://www.asg.com/
ASG-CloudFactory - The Single Solution to Build, Deploy  Manage your Cloud 
Environments
Click here for more information on the 
ASG-CloudFactoryhttp://www.asg.com/cloudfactory

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] set journal off working witth SQLiteConfig?

2013-03-14 Thread Richard Hipp 
On Wed, Mar 13, 2013 at 1:29 PM, Doug Crites doug.cri...@asg.com wrote:


 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?


I know nothing about the Java SQLiteConfig object.

Did you know you can change the journal mode directly using a pragma?  Have
you tried:

 PRAGMA journal_mode=OFF;

To see if that works for you?


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users