July 5, 2010 at 12:12 am
Hi,,
Need a Direction please as you suggest, or as brain storm.. We have 10 million image.tif file in “File System” ,organized by ID number, folder number, image number. In average from 30k to 100k, this scanned for the past 8 years. Our daily scan as new document is around 2000 image. Total over all disk space used for now around 900GB. Each person has many documents in average of 30 to 70 documents in his folder. Maximum number as I know 1 million people for another 10 years. As I see, It is the time to reorganize them and insert them in SQL Server Database, for best performance as they are small Image in size, control the growing size in hard disk space, easy recover and a lot more for future wise. My conserving, as I read the limit for filed is up to 2GB.
My question in mind,
1- What is the size or length on the filed I need to fit 70k of image as binary?
2- Which attribute is better for the field type? Text, binary, varchar? Or what?
3- Is is a good Ide to have for each person one field? Then keep inserting his entire document as one record up to 2GB? If not, why? what is the risk please..
4- Any Ide of how much I need for database size for the whole project?
5- In case for fast recovery needed, is it better If I divided them between smaller database size like around 250GB?
6- If I insert all the document image for each person in one record as binary, how can I separate them inside? In writing or reading process?
7- What do you think of deviding the 1T to 4X250GB Table? for future quiery and fast recovery and export import?
Thanks for your help in advance to all..
July 5, 2010 at 6:52 am
I would start by researching varbinary datatype.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply