Comparison between file Geodatabase and personal Geodatabase

After the SHP format is discarded, The Geodatabase of the personal Geodatabase type is used to store GIS data.File Geodatabase turned a blind eye and always thought that the efficiency of personal geodatabase is much higherFile Geodatabase, I did not expect it to be wrong, in fact, the opposite is true. The following is a comparison and will be used later.File GeodatabaseForget it.

 

I. Storage Methods

file geodatabase is stored as a folder, while personal geodatabase is an mdb database file with MS-access.

Ii. Storage restrictions
1. Personal Geodatabase: Same as the MS accesss limit, the maximum size of the database is 2 GB.
2. File Geodatabase: the database is unrestricted. Each table is limited to 1 Tb (1000 GB ).

Iii. platform support
1. Personal Geodatabase: runs only on Windows.
2. File Geodatabase: cross-platform support, available in windows and Unix , Run on Linux.

Iv. Performance
Compared with personal Geodatabase, file geodatabase is 20% to 10 times faster. As the amount of data increases, the efficiency is significantly different.

5. Storage space
Similarly, in file Geodatabase, less disk space is occupied than in personal Geodatabase and shapefile, which can usually be reduced by 50% ~ 70%, can be reduced to 1/5 at most.

Vi. compression format
File Geodatabase supports a new compression format, which is the same as the uncompressed format in query and display. The compression ratio ranges from.