Thanks for the insights ... Filesystem was infact working perfect for me.Was wondering how efficient BLOB makes my application.
The thread removes a lot of wrong perceptions about BLOB @Ryan can you send me the links where you have the literature about BLOB v putting right under the surface Thanks Karthikeyan On Fri, Jan 21, 2011 at 4:23 AM, euromark <dereurom...@googlemail.com>wrote: > ok, so i take that one back! :) > > On 20 Jan., 23:39, Ryan Schmidt <google-2...@ryandesign.com> wrote: > > I agree with your points that storing files as files on disk is better > than putting them into a database column; there are many articles written on > this topic that agree with this assessment. However, I must disagree with > this one point: > > > > On Jan 20, 2011, at 16:22, euromark wrote: > > > > > - a) 33% more space needed (base64encoded) > > > > There's no reason to store them base-64 encoded (or encoded in any way) > in the database; they're just stored as blobs -- binary data -- and I don't > know of a reason why the database engine wouldn't just natively store that, > taking up roughly the same amount of space as it would to store it as a > regular file. > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com<cake-php%2bunsubscr...@googlegroups.com>For > more options, visit this group at > http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php