terryds Posted July 29, 2013 Share Posted July 29, 2013 Hi Can you tell me which one of storing avatars to mysql using BLOB or storing avatars to ftp is better? I'm a bit confused about BLOB in SQL... When to use it instead of using ftp? Link to comment Share on other sites More sharing options...
birbal Posted July 29, 2013 Share Posted July 29, 2013 (edited) There have been previous discussion about these if you search the forum. Filesystem would be better. If you use database there would as many database calls as your image. because on each request you can only pull and display one image, Unless you are making a sprite of your avatars and using css to display it. In that case you will have one request but managing sprite would be complex than single image processing. Database calls are slower than filesystem access. Apart from that storing in database will be easier to backup image data along with other data. Edited July 29, 2013 by birbal Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now