<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
SDF is using the SQLite database for storage. The SQLite has the
following size constraints:<br>
<br>
<tt>(10) Are there any known size limits to SQLite databases?<br>
<br>
Internally, SQLite can handle databases up to 2^40 bytes (1
terabyte) in size. But the backend interface to POSIX and Win32 limits
files to 2^31 (2 gigabytes).<br>
<br>
SQLite arbitrarily limits the amount of data in one row to 1
megabyte. There is a single #define in the source code that can be
changed to raise this limit as high as 16 megabytes if desired.<br>
<br>
There is a theoretical limit of about 2^32 (4 billion) rows in a
single table, but there is no way to test this limit without exceeding
the maximum file size, so it is not really an issue. There is also a
theoretical limit of about 2^32 tables and indices, but again it is not
really possible to reach this limit due to the file size constraint.<br>
<br>
The name and "CREATE TABLE" statement for a table must fit entirely
within a 1-megabyte row of the SQLITE_MASTER table. Other than this,
there are no constraints on the length of the name of a table, or on
the number of columns, etc. Indices are similarly unconstrained.<br>
</tt><br>
So, if there are no bugs in the implementation, the size should be
limited to 2 GB. You can read more about the SQLite format on:<br>
<a class="moz-txt-link-freetext" href="http://www.sqlite.org/">http://www.sqlite.org/</a><br>
<pre class="moz-signature" cols="72">
Regards, Kenneth, GEOGRAF A/S
</pre>
<br>
Rahul skrev:
<blockquote cite="mid:234962.38662.qm@web34506.mail.mud.yahoo.com"
type="cite">
<div>Hi All,</div>
<div> Can anyone tell me that how much the maximum SDF File
size(single) supported by Autodesk(ADSKServer,Map3D 2008).Any reference
or detail link will be really helpfull for me.</div>
<div> </div>
<div>ESRI use to provide support for max. 4 GB personal geodatabase
File.</div>
<div> </div>
<div>Thks</div>
<div>Max<br>
<br>
</div>
<p> </p>
<hr size="1">It's here! Your new message!<br>
Get
<a moz-do-not-send="true"
href="http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar/features/mail/">
new email alerts</a> with the free <a moz-do-not-send="true"
href="http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar/features/mail/">Yahoo!
Toolbar.</a>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
</body>
</html>