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
