file storage
Submitted by LouBabe on Thu, 05/01/2008 - 20:00.
Anyone know the best file storage option? I had mine stored in the database as that was the recommended option. However, after a year or so of use, my MySql database was so large that it become difficult to manage. That is, I was migrating to a different server, and had a tough time taking the over 70mb db with me. Realizing this problem would continue, I used the tool on the aC forums to migrate the files to the file system, truncated the db table, and switched to using the file system.
However, now I am getting some db lock issues, and am wondering if this is a solid and reliable approach? Future plans? Any suggestions would be welcome.
Hey LouBabe,
I would personally suggest using the filesystem (for the reasons you mentioned above).
I'm guessing that one of the reasons that database storage is recommended is that there aren't any directory permissions issues with storing files in the db.
If you could paste some of the errors you've been getting, then there might be a way to fix your filesystem problem.
Alex
Hi LouBabe,
Any chance you could send me the link to the migration tool you found on the aC forums - I can't seem to find it anywhere.
Adrian