<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I have not tested this, only looked at it in theory. It looks as if the
provider can support at least 2GB, but there might be a limitation deep
inside Map3D.<br>
Maybe some of the Autodesk people have tested this?<br>
<br>
<pre class="moz-signature" cols="72">Regards, Kenneth, GEOGRAF A/S
</pre>
<br>
<br>
Rahul skrev:
<blockquote cite="mid:281095.98384.qm@web34506.mail.mud.yahoo.com"
type="cite">
<div>Hi ,</div>
<div> Thanks a lot for your detail reply and reference,so in
theory we can say that it can support upto 2 TB depending upon the
storage space and File System.</div>
<div> </div>
<div>I think leave about the TB and if we talk just about 2-3 GB ,do
u think it is possible to work with a SDF File of 2-3 GB in Autodesk
assuming that storage space is not an issue.(Similar to ESRI Personal
GeoDatabase 4 GB Limit).</div>
<div> </div>
<div>Thks</div>
<div>Max<br>
<br>
<b><i>"Kenneth, GEOGRAF A/S" <a class="moz-txt-link-rfc2396E" href="mailto:ks@geograf.dk"><ks@geograf.dk></a></i></b> wrote:</div>
<blockquote class="replbq"
style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: 5px;">Hmm...
a bit hasty there... the new info shows this:<br>
<br>
<tt>(10) Are there any known size limits to SQLite databases?<br>
<br>
A database is limited in size to 2 tibibytes (2^41 bytes). That is
a theoretical limitation. In practice, you should try to keep your
SQLite databases below 100 gigabytes to avoid performance problems. If
you need to store 100 gigabytes or more in a database, consider using
an enterprise database engine which is designed for that purpose.<br>
<br>
The theoretical limit on the number of rows in a table is 2^64-1,
though obviously you will run into the file size limitation prior to
reaching the row limit. A single row can hold up to 230 bytes of data
in the current implementation. The underlying file format supports row
sizes up to about 2^62 bytes.<br>
<br>
There are probably limits on the number of tables or indices or the
number of columns in a table or index, but nobody is sure what those
limits are. In practice, SQLite must read and parse the original SQL of
all table and index declarations everytime a new database file is
opened, so for the best performance of sqlite3_open() it is best to
keep down the number of declared tables. Likewise, though there is no
limit on the number of columns in a table, more than a few hundred
seems extreme. Only the first 31 columns of a table are candidates for
certain optimizations. You can put as many columns in an index as you
like but indexes with more than 30 columns will not be used to optimize
queries.<br>
<br>
The names of tables, indices, view, triggers, and columns can be as
long as desired. However, the names of SQL functions (as created by the
sqlite3_create_function() API) may not exceed 255 characters in length.<br>
<br>
</tt>So, it should in fact support 2 titibytes, providing that the
file system allows you to create files of that size (and you have
enough storage space).<br>
<pre class="moz-signature" cols="72">Regards, Kenneth, GEOGRAF A/S </pre>
<br>
<br>
Kenneth, GEOGRAF A/S skrev:
<blockquote cite="mid:466CEB4A.9060006@geograf.dk" type="cite">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/"
moz-do-not-send="true">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>
<hr size="1"> It's here! Your new message!<br>
Get <a
href="http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar/features/mail/"
moz-do-not-send="true">new email alerts</a> with the free <a
href="http://us.rd.yahoo.com/evt=49938/*http://tools.search.yahoo.com/toolbar/features/mail/"
moz-do-not-send="true">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" moz-do-not-send="true">mapguide-users@lists.osgeo.org</a> <a
class="moz-txt-link-freetext"
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"
moz-do-not-send="true">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a> </pre>
</blockquote>
<pre wrap=""><hr size="4" width="90%"> _______________________________________________ mapguide-users mailing list <a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a> <a
moz-do-not-send="true" 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>
_______________________________________________<br>
mapguide-users mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</blockquote>
<br>
<p> </p>
<hr size="1">Yahoo! oneSearch: Finally, <a moz-do-not-send="true"
href="http://us.rd.yahoo.com/evt=48252/*http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC">
mobile search that gives answers</a>, not web links.
<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>