Working with images in WCF
        Posted  
        
            by hgulyan
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by hgulyan
        
        
        
        Published on 2010-03-18T05:51:12Z
        Indexed on 
            2010/03/18
            6:01 UTC
        
        
        Read the original article
        Hit count: 372
        
Hi, I have a desktop application that needs to upload/download images to/from service computer over TCP Protocol.
At first, I stored images in file system, but I need to in MS SQL DB to compare which solution is better. Number of images is over half a million. I don't know yet will there be any limitation on size of a photo.
If you have done smth like that, please, write what your opinion upon this question.
Which one is faster, more safe? Which of them works better with this number of photos? If I'll store on DB, do I need to store images apart from all other tables which I use for my application and which type works better - image or varbinary on DB?..and so on.
Thank you.
© Stack Overflow or respective owner