jamesjmann Posted February 23, 2011 Share Posted February 23, 2011 Is it better to store actual image data in Mysql or just the url to the image on your server? I currently just store the url so when I display images on my page, I do something like this: <a href="$url"><img src="$url"></a> Does anyone know which method big sites like Facebook uses? I'm trying to figure out which method is best, because I'm currently designing a social networking site, and of course, finding a suitable method of storing user data such as this is integral. Quote Link to comment https://forums.phpfreaks.com/topic/228644-general-question/ Share on other sites More sharing options...
Muddy_Funster Posted February 23, 2011 Share Posted February 23, 2011 that question borders on the phylosophical as far as database storge goes. Personaly I would do as you are doing, blobs can be a bit messy at times when it comes to formating the data return. Also, I am under the impression that you can get better compression on the raw file than you can on a blob entry. Just my two pence worth, like I said, you'd have been as well asking for the meaning of life Quote Link to comment https://forums.phpfreaks.com/topic/228644-general-question/#findComment-1178892 Share on other sites More sharing options...
jamesjmann Posted February 23, 2011 Author Share Posted February 23, 2011 that question borders on the phylosophical as far as database storge goes. Personaly I would do as you are doing, blobs can be a bit messy at times when it comes to formating the data return. Also, I am under the impression that you can get better compression on the raw file than you can on a blob entry. Just my two pence worth, like I said, you'd have been as well asking for the meaning of life lol. is that how websites like facebook does it? Quote Link to comment https://forums.phpfreaks.com/topic/228644-general-question/#findComment-1178897 Share on other sites More sharing options...
Muddy_Funster Posted February 23, 2011 Share Posted February 23, 2011 To be honest, I dont know, I don't have time for (anti)social networking sites, I like going to the pub too much Quote Link to comment https://forums.phpfreaks.com/topic/228644-general-question/#findComment-1178903 Share on other sites More sharing options...
jamesjmann Posted February 23, 2011 Author Share Posted February 23, 2011 To be honest, I dont know, I don't have time for (anti)social networking sites, I like going to the pub too much lol ok. guess i can try talking to a facebook executive and see what i can weedle out of him haha Quote Link to comment https://forums.phpfreaks.com/topic/228644-general-question/#findComment-1178909 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.