Well, I know that filesystem is going to be faster for this one, but I want to know by how much. So, I've set myself the talks of measuring it, when I get any spare time, of course :)
phpMyScaffold can store blobs for web site images, and I wonder how far I can take the 'scaffolding' nature of PMA-based sites into a low-traffic production environment.
Stay tuned for the results, or if you have any comments, suggestions for the test!
UPDATE: Filesystem is about 10x faster than BLOB! I dont have time right now to write up the method and results… hopefully soon :)
I only recently got into web-based development using MySQL. I'm great at everything PHP and MySQL except how to best develop photo galleries for my clients. To date, I have implemented 7 custom galleries and they're all different.
I've been trying to find some information on BLOB vs File System performance, lately, and I've been coming up dry.
Most people seem to talk about the "age-old debate" but nobody comments on the speed.
I'm so glad you've cleared this one up for me! Although, could I trouble you for a more detailed write-up?
I am very interested in the finer details of why file system out-performs BLOB.