As I've recently learned, portability across different platforms begins to be a real headache for files greater than 4 GB. All have drive formats and architecture that can support big files, but they are not common across platforms.
Michael ______________________________ C. Michael Barton Director, Center for Social Dynamics & Complexity Professor of Anthropology, School of Human Evolution & Social Change Arizona State University Tempe, AZ 85287-2402 USA voice: 480-965-6262 (SHESC), 480-727-9746 (CSDC) fax: 480-965-7671(SHESC), 480-727-0709 (CSDC) www: http://csdc.asu.edu, http://shesc.asu.edu http://www.public.asu.edu/~cmbarton On Feb 14, 2013, at 5:55 AM, [email protected]<mailto:[email protected]> wrote: From: Markus Metz <[email protected]<mailto:[email protected]>> Subject: Re: [GRASS-user] getting from DBF to SQLite Date: February 14, 2013 1:38:57 AM MST To: Hamish <[email protected]<mailto:[email protected]>> Cc: GRASS user list <[email protected]<mailto:[email protected]>> On Thu, Feb 14, 2013 at 12:50 AM, Hamish <[email protected]<mailto:[email protected]>> wrote: Richard wrote: Is it is possible to set a single SQLite database for the entire GRASS GIS database or each mapset requires its own sqlite db file? organize your system as you like, but be sure to ask yourself what happens to portability with 32bit machines and/or filesystems when the overall DB file gets to be larger than 2gb or 4gb in size. The maximum file size of a SQLite db is 140 TB, independent of the architecture, i.e. LFS is always there. Usually SQLite will hit the maximum file size limit of the underlying filesystem or disk hardware size limit long before it hits its own internal size limit [0]. Markus M [0] http://www.sqlite.org/fileformat2.html Even per-mapset sqlite DBs worry me a bit for that, not to mention the damage-fallout from a bad HD sector or accidental `rm` and ease of moving stuff to another mapset/ system by hand. Hamish _______________________________________________ grass-user mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/grass-user
_______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
