Re: [sqlite] difference in file size netween MAC and Windows

[Lidia Kalinovsky]

thanks a lot.


On Wed, Feb 26, 2014 at 5:34 PM, Clemens Ladisch <clem...@ladisch.de> wrote:

> Lidia Kalinovsky wrote:
> > Attached are 2 db empty (no data) files
>
> This list does not allow attachments.
>
> > There is big difference in file size - file created on Windows is match
> > smaller than MAC one.
>
> Due to differences in the way these OSes report the sector size,
> the default page size is different.
>
> If this matters for you, change it before actually creating the
> database file:
> <http://www.sqlite.org/pragma.html#pragma_page_size>
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Software integration and outsourcing services,
Lemur-Soft, Giv'at Nili
Israel, 37825
Phone : (+972) 545748325
Fax : (+972) 775345383
Email : li...@lemur-soft.com
Web: www.lemur-soft.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] difference in file size netween MAC and Windows

[Lidia Kalinovsky]

Hello

Attached are 2 db empty (no data) files, created with same code.
MAC.sqlite is created on MAC and Windows.sqlite is created on Windows.

We use sqlite3.lib on Windows and libsqlite3.dylib on MAC.
There is big difference in file size - file created on Windows is match
smaller than MAC one.
This is significant difference for our application.

Can somebody advice ?

Thanks.
Lidia.

-- 
Software integration and outsourcing services,
Lemur-Soft, Giv'at Nili
Israel, 37825
Phone : (+972) 545748325
Fax : (+972) 775345383
Email : li...@lemur-soft.com
Web: www.lemur-soft.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users