topic Re: Personal and File geo database difference of size in ArcGIS Mapping and Charting Questions

Personal and File geo database difference of size

OrkhanAbdullayev — Wed, 22 May 2019 13:34:06 GMT

I have .mdb (personal database) in ArcMap 10.3, I load files and it almost 2GB (the max size of personal gdb) and after I create File database (.gdb) and load again the same files but this time it took only 90mb. Am I doing something wrong or it is as it is?

another thing is when I copy my file gdb within the folder to another local disc, I need to set the data source link again, but for personal did not face this problem. (maybe it is because of personal database saves its data in access)

Re: Personal and File geo database difference of size

Egge-Jan_Pollé — Wed, 22 May 2019 14:52:25 GMT

Hi Orkhan Abdullayev‌,

Esri's Personal Geodatabase format is - as you already noticed - based on the Microsoft Access (MDB) database format. And MDB files tend to grow quickly as you use them, sometimes impeding performance. You might try a Compact and repair to see if you can shrink the MDB.

But in general a File Geodatabase, Esri's proprietary database format, will be more efficient and hence smaller in size.

Here you will find a nice comparison between the Personal and the File Geodatabase (and even the good old shapefile):

What is a Geodatabase? Personal vs File Geodatabase - GIS Geography

My advice would be to forget about the Personal GDB and stick with the File GDB...

HTH,

Egge-Jan

Re: Personal and File geo database difference of size

OrkhanAbdullayev — Wed, 22 May 2019 15:01:38 GMT

Hi Egge-Jan Pollé

Thank you for your fast reply and useful information also your valuable time.

Best Regards

Orkhan

Re: Personal and File geo database difference of size

Egge-Jan_Pollé — Wed, 22 May 2019 15:08:23 GMT

If you think your question is answered, you might mark the answer as correct.