I am working on an extensive Real Estate Application in PHP/MYSQL and want to store files in the MYSQL DB to maintain security of the documents. Can anyone tell me how reliable is it is storing those files in DB and what effect it will have in application performance.
Don't store files in the database, but a link to an unique file wich contains the document. Set the right CHMOD permissions to only allow the script to use the file! Why not storing files in database; a database isn't build for storing files, and searching will be less powerfull! Harddisk = for files Database = for records linking to files, and so on!
But in the case that my application is installed on a windows environment so what will be the case. CHMOD will not work
Just hold the files somewhere that is not accessible via the web. In a cPanel environment an example would be above the public_html directory, possibly in a folder called 'files'. Dan