View Full Version : Bandwidth performance for attachements


mrbister
14th October 2004, 11:08 AM
Anyone with a solution to this problem? I've read doc/fac, etc, but no go...

I've many attachements stored in "file system", not db, but some were to large so I just put the files there and made a url-link to the file.

My problem is that downloading files as attachments give me an average speed of 100KB/s, but when I use a http://...... to files I get 500-600KB/s. Even tried it on the same file (virtual directory, compared to vB attachement, same server, same folder). How come vB only gives a fifth of the normal file performance?

-MrBister

martini
21st October 2004, 03:58 PM
are you sure you move the file from your DB?

mrbister
21st October 2004, 08:33 PM
yes, I've verified that all files are copied to correct file directory, not db. I don't think db storage is suitable for files that sometimes are up to 40MB.-MrBister

mrbister
22nd October 2004, 02:35 PM
I took a screendump to compare speed from the same folder as the .attach file from vbulletin resides in:
Always roughly 5 times the performance when testing.
No one here who uses attachments in their forum???

http://www.filbunken.com/vb_sux.jpg

martini
23rd October 2004, 04:55 AM
I think when you download as attachment, actually you are downloading through the DB.

mrbister
23rd October 2004, 11:27 AM
Help http://www.filbunken.com/forum/cpstyles/vBulletin_3_Default/cp_help.gif (http://www.filbunken.com/forum/admincp/attachment.php?do=stats#)
Statistics Total Attachments;56
Disk Space Used;304.71 MB
Storage Type;
Attachments are currently being stored in the filesystem at files
Average Attachment Filesize;5.44 MB
Total Downloads;145

That's what vbulletin attachments settings says.

Latest post is:
....../forum/attachment.php?attachmentid=61 (http://www.filbunken.com/forum/attachment.php?attachmentid=61)

Clicking on that one gives me 80-100KB/s.
If I instead enter: ....../forum/files/1/61.attach and download the file I get 500K/s.
The only diff is that when I grab it from the forum vBulleting tells my browser it's a media file (mpeg), but when browsing directly I just download the .attach file.

Why the speed limit from vBulletin?

Floris
19th November 2004, 05:42 AM
Help http://www.filbunken.com/forum/cpstyles/vBulletin_3_Default/cp_help.gif (http://www.filbunken.com/forum/admincp/attachment.php?do=stats#)
Statistics Total Attachments;56
Disk Space Used;304.71 MB
Storage Type;
Attachments are currently being stored in the filesystem at files
Average Attachment Filesize;5.44 MB
Total Downloads;145

That's what vbulletin attachments settings says.

Latest post is:
....../forum/attachment.php?attachmentid=61 (http://www.filbunken.com/forum/attachment.php?attachmentid=61)

Clicking on that one gives me 80-100KB/s.
If I instead enter: ....../forum/files/1/61.attach and download the file I get 500K/s.
The only diff is that when I grab it from the forum vBulleting tells my browser it's a media file (mpeg), but when browsing directly I just download the .attach file.

Why the speed limit from vBulletin?I think this is a typical question for vBulletin support team over at vBulletin.com and goes beyond our low level support.

If you upload an attachment, it will be stored in the database.
If you set to not store in the database, but to the file system it will be stored where also the .php files are.

If you want to download these attachments from your web server you can ftp in and download them using ftp. Or .gz them up first and download that .gz backup.

For database stored attachments you can only download them through the post they are posted in.