I've been thinking about the "right" way to work with geodatabases:
I'm a GIS analyst and my everyday work consists of delivering different GIS products (Maps, Geographic calculations, etc.) for different projects. The data for the products also comes from different sources.
I am currently making a file geodatabase for each product that contains the results and the temporary layers. That FGDB resides within a project-specific folder that also contains the MXD file and other files needed for the product (Excel files, Images, etc.)
Wouldn't it be more efficient to put all the products for all the projects in one large FGDB, divided into Feature Datasets?
How big can a FGDB get before the performance starts to decline?
I also have access to an Oracle geodatabase (using ArcSDE). Would that be a better choice?
I'm curios to know what you think.