> But I think at least
> Sqlite3 should have used most space on the sector when it request a new
> sector.
Due to internal SQLite specifics it uses at least 1 page for each
table and index. So even if you don't store there anything with a big
schema database will still consume significant amount of disk space.
Probably from your point of view it's a waste of space but it's
necessary trade-off to make it light.
> Maybe I need to return a smaller number when querying the sector
> size.
Read the link Dan gave you. Issuing 'pragma page_size' before creation
of any tables in the database is enough.
Pavel
On Tue, May 11, 2010 at 4:29 AM, Lei, Rick (GE EntSol, SensInsp)
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 the sector when it request a new
> sector. It looks like that the Sqlite wastes a lot of space on SDHC
> card. Of course the space is not a problem now. Because we can easily
> find a 8G or 16G SDHC card. However I think we still need to take care
> of it. Maybe I need to return a smaller number when querying the sector
> size.
>
> BR
> Rick
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-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,
>>
>> 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 full filled with 0 in the file. And I can't find
>
>> these parts in the files generated on PC side. I don't know why the
>> files are different between PC side and instrument side. I think they
>> should be same. Is there any advice?
>
> Different page sizes.
>
> http://www.sqlite.org/pragma.html#pragma_page_size
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
