ArcSDE Size/Performance with Thousands of Attachments

Discussion created by poet_will on Jan 17, 2014
Latest reply on Jan 13, 2016 by jmmiller
Hello, I have been trying to find some information regarding size and performance issues in regards to attachments to features in ArcSDE.  I am currently using 10.2.  Here is an example of what I would like to do.  I have a layer of 10,000+ points.  I have three or more images and pdfs that need to be associated with each of the points.  How would the ArcSDE geodatabase handle all of these attachments?  I have tried hyperlinking the images and pdfs using the "Add Hyperlink..." option in the Identify tool, but the hyperlinks are not saved to the layer/feature.  I could use fields for hyperlinks in the layers but I would have to have at least five (and sometimes many more) hyperlink fields in each layer. 

The end result I want is to have the end-user be able to click on feature and in some way have access to all of the documents associated with that feature be available (pdfs and images).

Thanks for the help.