topic Feature Class in File Geodatabase taking Much Less Disk Space than when in SQL Server Geodatabase in Data Management Questions https://community.esri.com/t5/data-management-questions/feature-class-in-file-geodatabase-taking-much-less/m-p/115722#M6583 <HTML><HEAD></HEAD><BODY><P>I have compared feature-class disk-space usage between file-geodatabase format and SQL Server. I have found disk space used in SQL Server to be about 2.7-3.3 times larger in SQL Server (not including log-file space in SQL Server).</P><P></P><P>I used <STRONG>sp_spaceused</STRONG> to get table (feature class) disk-space numbers from SQL Server.</P><P></P><P>Why is there such a large difference? I understand that these 2 databases store geometries in different ways. Is the file-geodatabase format super efficient w/ storage?</P></BODY></HTML> Tue, 02 Jul 2019 14:16:24 GMT IvanBrown 2019-07-02T14:16:24Z Feature Class in File Geodatabase taking Much Less Disk Space than when in SQL Server Geodatabase https://community.esri.com/t5/data-management-questions/feature-class-in-file-geodatabase-taking-much-less/m-p/115722#M6583 <HTML><HEAD></HEAD><BODY><P>I have compared feature-class disk-space usage between file-geodatabase format and SQL Server. I have found disk space used in SQL Server to be about 2.7-3.3 times larger in SQL Server (not including log-file space in SQL Server).</P><P></P><P>I used <STRONG>sp_spaceused</STRONG> to get table (feature class) disk-space numbers from SQL Server.</P><P></P><P>Why is there such a large difference? I understand that these 2 databases store geometries in different ways. Is the file-geodatabase format super efficient w/ storage?</P></BODY></HTML> Tue, 02 Jul 2019 14:16:24 GMT https://community.esri.com/t5/data-management-questions/feature-class-in-file-geodatabase-taking-much-less/m-p/115722#M6583 IvanBrown 2019-07-02T14:16:24Z Re: Feature Class in File Geodatabase taking Much Less Disk Space than when in SQL Server Geodatabase https://community.esri.com/t5/data-management-questions/feature-class-in-file-geodatabase-taking-much-less/m-p/115723#M6584 <HTML><HEAD></HEAD><BODY><P>I would review this thread from the last few weeks:&nbsp;<A _jive_internal="true" href="https://community.esri.com/thread/235224-feature-classes-quadruples-in-size-when-imported-to-sde">https://community.esri.com/thread/235224-feature-classes-quadruples-in-size-when-imported-to-sde</A><BR /><BR /><A href="https://community.esri.com/group/1680">Geodatabase</A>&nbsp;<A href="https://community.esri.com/space/2053">Enterprise GIS</A></P></BODY></HTML> Tue, 02 Jul 2019 14:26:17 GMT https://community.esri.com/t5/data-management-questions/feature-class-in-file-geodatabase-taking-much-less/m-p/115723#M6584 George_Thompson 2019-07-02T14:26:17Z