<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I have tested with a 6GB+ file. This was a long time ago (may be
2 Map releases back).<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Traian<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Kenneth,
GEOGRAF A/S<br>
<b>Sent:</b> Monday, June 11, 2007 5:06 AM<br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> Re: [mapguide-users] SDF File Size(Maximum)<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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>
<br>
<o:p></o:p></p>
<pre>Regards, Kenneth, GEOGRAF A/S<o:p></o:p></pre>
<p class=MsoNormal><br>
<br>
Rahul skrev: <o:p></o:p></p>
<div>
<p class=MsoNormal>Hi ,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> 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.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>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).<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Thks<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Max<br>
<br>
<b><i>"Kenneth, GEOGRAF A/S" <a href="mailto:ks@geograf.dk"><ks@geograf.dk></a></i></b>
wrote:<o:p></o:p></p>
</div>
<blockquote style='border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=MsoNormal>Hmm... a bit hasty there... the new info shows this:<br>
<br>
<tt><span style='font-size:10.0pt'>(10) Are there any known size limits to
SQLite databases?</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br>
<br>
<tt> 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.</tt><br>
<br>
<tt> 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.</tt><br>
<br>
<tt> 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.</tt><br>
<br>
<tt> 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.</tt><br>
<br>
</span>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>
<br>
<o:p></o:p></p>
<pre>Regards, Kenneth, GEOGRAF A/S <o:p></o:p></pre>
<p class=MsoNormal><br>
<br>
Kenneth, GEOGRAF A/S skrev: <o:p></o:p></p>
<p class=MsoNormal>SDF is using the SQLite database for storage. The SQLite has
the following size constraints:<br>
<br>
<tt><span style='font-size:10.0pt'>(10) Are there any known size limits to
SQLite databases?</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br>
<br>
<tt> 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).</tt><br>
<br>
<tt> 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.</tt><br>
<br>
<tt> 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.</tt><br>
<br>
<tt> 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.</tt><br>
</span><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 href="http://www.sqlite.org/">http://www.sqlite.org/</a><br>
<br>
<o:p></o:p></p>
<pre>Regards, Kenneth, GEOGRAF A/S <o:p></o:p></pre>
<p class=MsoNormal><br>
Rahul skrev: <o:p></o:p></p>
<div>
<p class=MsoNormal>Hi All,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> 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.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>ESRI use to provide support for max. 4 GB personal
geodatabase File.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Thks<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>Max<o:p></o:p></p>
</div>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=1 width="100%" align=center>
</div>
<p class=MsoNormal>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/">new
email alerts</a> with the free <a
href="http://us.rd.yahoo.com/evt=49938/*http:/tools.search.yahoo.com/toolbar/features/mail/">Yahoo!
Toolbar.</a> <o:p></o:p></p>
<pre style='text-align:center'>
<hr size=4 width="90%" align=center>
</pre><pre> _______________________________________________ mapguide-users mailing list <a
href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a> <a
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a> <o:p></o:p></pre><pre
style='text-align:center'>
<hr size=4 width="90%" align=center>
</pre><pre> _______________________________________________ mapguide-users mailing list <a
href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a> <a
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a> <o:p></o:p></pre>
<p class=MsoNormal>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><o:p></o:p></p>
</blockquote>
<p class=MsoNormal><o:p> </o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=1 width="100%" align=center>
</div>
<p class=MsoNormal>Yahoo! oneSearch: Finally, <a
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. <o:p></o:p></p>
<pre><o:p> </o:p></pre><pre style='text-align:center'>
<hr size=4 width="90%" align=center>
</pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>mapguide-users mailing list<o:p></o:p></pre><pre><a
href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><o:p></o:p></pre><pre><a
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><o:p></o:p></pre><pre> <o:p></o:p></pre></div>
</body>
</html>