Tuesday, February 13, 2007
I spent so much time last night trying to store thumbnails into mysql. I've always wanted to know if it was faster. So finally I did store it, but guess what, using the filesystem as thumbnail storage was faster. I was getting 2-3 secs total execution time when visiting a new gallery with no thumbnails yet when stored to mysql. While on the reiserfs it was like 1-2 secs, then after the thumbnails are generated it takes less than 0.20 secs to render a page but with mysql its like 0.35 or something then it just keeps getting higher the more thumbnail you have on the page.