Hi Donald, Thanks for your warmly help.Yes, I am working on POS terminal which is based on WinCE platform. After carefully reading the article you sent to me, I had a deep understanding of SQLITE transaction. For your suggestion, I think the first one is good for me since our project will be released soon and I do not have much time to do compression work. And I have a further question for the first solution, if the power was off during the multiple delete transaction, for example, transaction 1 finished and transaction 2 not started, will it caused that I only delete partial data of my database? Do you have any comments on this case? Regards,Tim
> From: donald.gri...@allscripts.com > To: sqlite-users@sqlite.org > CC: bh_s...@hotmail.com > Date: Thu, 25 Mar 2010 12:41:28 -0400 > Subject: RE: [sqlite] sqlite3 error: database or disk is full when commit > transaction > > Tim, > > Regarding: "I guess when do the transaction, the database was duplicated, > and it caused no free disk space" > > > Unless you do something such as "vacuum" the database should not actually be > duplicated. A rollback journal file, > though, **is** created. > (details at http://www.sqlite.org/atomiccommit.html and elsewhere) > > > Others on this list can likely give better advice, but I wondered if: > 1) Perhaps deleting only part of the table in multiple transactions would > help. > 2) If your operating system allows it, you might experiment with applying > transparent compression to the database directory and perhaps more. > 3) If #2 is not feasible, would applying compression yourself to certain > data fields be worthwhile? > > I assume you're working with an embedded device of some sort which would > explain such severe memory constraints? > > Donald _________________________________________________________________ The New Busy is not the old busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL:ON:WL:en-US:WM_HMP:032010_3 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users