I run a music forum, and was thinking about using the new "Attach File" feature of 2.0 to allow users to attach .mp3's to their posts... Is this feasible, or is php or mysql likely to time out during the lengthened file transfer?
File upload sizes
Collapse
X
-
Tags: None
-
-
-
What's wrong with storing it in MySQL?
Do you realize what an installation support nightmare it would be to have to deal with CHMODing directories and all that? Do you remember the feeling you got in your stomach when UBB support told you that you had to CHMOD a directory to 777? And you had no idea what CHMODing was?? I'd rather not go there...
-jimComment
-
Jim... I download my database very often. I hate it seing getting bigger and bigger because users put tons of files in it.
+ i like to htaccess the directory where I store the images users upload so no one can use it on their site.
I really prefer to chmod directories (cmon this takes like 30 seconds).
Result I simply will disable the feature :/Comment
-
Attachments are stored in the db???? Ok now I'm worried I heard some bad stuff about speed and problems with that.... I would like an option if possible to store the files in a directory and store their links in the db...... Other wise I just might turn it off<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
*--------* (IN THE NAME Of ALLAH THE MOST MERCIFUL) *------*
============================================================
=================== Turki M. Al-Ballaa =================
============================================================
I am a Saudi, I am an Arab, I am a Muslim, I am a Human!!
@@ All Humans are one, the only difference is in faith.@@
So peace and prosperity to all, may we all live in harmony.
Salam! Peace!
www.arabianoasis.net
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>Comment
-
Originally posted by SAWolf76
Attachments are stored in the db???? Ok now I'm worried I heard some bad stuff about speed and problems with that.... I would like an option if possible to store the files in a directory and store their links in the db...... Other wise I just might turn it offComment
-
the database has no problems in being huge in size initself, remember a database is just a way of storing files on a server, they are still files (or part of a big file) somewhere.
The thing i don't like about this file in database things are:
i) backing up becomes a nightmare. I want to have my database emailed me weekly if not daily, if it gets to be 1GB then this is clearly not an option, even taking it off server is going to start costing $5 per day. A GB is also not really that unreasonable with the amount of images and files that could get uploaded.
ii) maintenance. Want to delete them? well not so easy really, so much easier to see what is there, file size etc in ftp folder.
iii) moving them? what if you want to move them elsewhere?
iv) and extra mysql call everytime they are loaded (i imagine this must be the case? but perhaps it would not make a difference i don't know?).
v) This is the BIGGEST. Bandiwdth theft. I have to pay
$5/GB for bandwidth after my allocation so i am concerned about this. If the images/files where in a set directory bandwidth theft can be prevented by .htaccess and http.conf. This is, as far as i know, unbreakable. The protection you can put on scripts using the referre tag is both unreliable and no way full proof. This is so so annoying, when people start finding their sites is used as smiles, avatars and general uploaded files repoisitries they are going to complain.
vi) max database sites. Those with database sizes limited by their virtual host to say, 2MB are in trouble.
===
Advantages:
i) security issues. You could argue that files being uploaded is a security problem. Really? So long the script does not chmod them wrong i don't really see how but i do not know that much about this.
ii) no need to chmod 1 directory to 777. Not exactly that hard a performance. The comparison between that an UBB where you have to chmod massive of files and directories etc is not really fair. Plus, if you know how to use mySQL to get the script installed my guess is you know how to CHMOD a directory. Not exactly the steapest of learning curves
Have to say, i will also have to disable this feature, the bandwidth being the main problem. Luckily i am going to use my links SQL program to allow people to upload files seaminglessly and then call then using VB code have the program add them to the post. Should solve problems and give me good file management capabilities.Comment
-
We are in the same boat chrispadfield.
The fact is that i'm almost SURE jelsoft will change this in a near future because lots of users will complain about it.
They will have to make a script to move the files out of the database for those that would have used the feature....
As I told earlier, it would be much easier for Jelsoft just to release 2.0 with a non database file storing system than make it later under pressure of users. (or of course, make it an option so we can choose which way we want).
What I really like with VB is how easy its to backup, move, download , store and archive the database.
This gets ruined with the files in it and database getting mega big.Last edited by Sharg; Fri 9 Feb '01, 1:58pm.Comment
-
yup and remember it is not just attachments but avatars too although i symphaize with avatars being in the database a "bit" more but not that much moreComment
-
i think jelsoft will find out though, vb-world is probably going to have lots of attachments with coders there so lots of nice zip files, as their database ballons the hope is they will "see the light"Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment