On Sat, Mar 27, 2010 at 04:44:56PM +0800, Tim scratched on the wall: > Hi Donald&Jay, > > Thanks for your information. And I don't know how to reach Jay kreibich's > email address, so I CC this mail to 'General Discussion of SQLite Database'. > > Could you please help me forward to Jay Kreibich if he cannot receive it.
My email is "j...@kreibi.ch", just like the headers say. It is just an email address like any other. If your mail system can't process that address you should be thinking about finding a new service provider. (And for those wondering, Switzerland. I'm in Illinois, however.) > For the *easiest* way, I tried by turning off the journal mode in my > application, it will not generate journal file any more when delete > performed. But I found the speed of update database is EXTREMELY slow( I > have about 8000 records to insert into the database). Turning journaling off disables transactions, so each insert will be processed as a unique event. That's going to be very slow. As long as you're living dangerously, you could turn off syncing as well. > And the second concern > is that if I turn off the journal mode, SQLITE will not roll back even if I > using transactions, am I right? If you turn off journaling the database no longer has transactions. So, correct, no ROLLBACKs. No BEGIN or COMMIT either. Any logical error will cause bad data in the database, any environmental error is likely to leave you with a corrupt database. Turning journaling off gets rid of many of the reasons you use a database in the first place. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
