Database
Subject: Re: [sqlite] synchronous issue
On 9 Aug 2010, at 7:13am, Lei, Rick (GE EntSol, SensInsp) wrote:
> In order to reduce the operation time, I set synchronous as OFF and
> journal_mode as MEMORY by PRAGMA command. However I found that the
data
> may be lost after inserting a
Hi,
In order to reduce the operation time, I set synchronous as OFF and
journal_mode as MEMORY by PRAGMA command. However I found that the data
may be lost after inserting a BLOB data, even when I use a commit
action. I think the reason is synchronous is off. How can I know that
there is some
PC
sideandinstrumentside.
On 12 May 2010, at 2:39am, Lei, Rick (GE EntSol, SensInsp) wrote:
> Another question is if Sqlite uses at least 1 page for each table and
index, does it means if the contents in a table doesn't fill 1 page,
Sqlite will not request a new page when operating this ta
May 11, 2010 at 4:29 AM, Lei, Rick (GE EntSol, SensInsp)
<rick@ge.com> wrote:
> Hi, Dan,
>
> Yes, I noticed this setting. The sector size in SDHC card is 4Kbyte
> which is different from the size of harddriver. But I think at least
> Sqlite3 should have used most space on th
Try to use transaction syntax.
Rick
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of �L�~
Sent: Tuesday, May 11, 2010 1:48 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Insert large data question ??
Dear
I have about 9
-users-boun...@sqlite.org] On Behalf Of Dan Kennedy
Sent: Tuesday, May 11, 2010 4:18 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] DB files are different between PC side and
instrumentside.
On May 11, 2010, at 2:54 PM, Lei, Rick (GE EntSol, SensInsp) wrote:
>
> Hi,
>
&
Hi,
I ported Sqlite3 to my instrument. The database file is stored in a SDHC
card. Sqlite3 runs ok. However I found the database file generated on
instrument side is much bigger than the file on PC side. I checked the
files generated on instrument by UltraEdit. I found a lot of space which
is
7 matches
Mail list logo