attachments as files etc

[corsacrazy]

Ok please read till the end and DONT close this thread till you have read

I am thinking of moving my attachements from database into a folder. my questions are

1. What happens to the thumbnailed pics?
2. my stats are as follows : Attachment Disk Usage77.22 MB
   If i move to files will this drop and make forum faster?
3. will attachments be automatically removed from databse when its finished making the files
4. How long will it take to move 77.22mb from databse to files ?

cheers

[Jake Bunce]

1) The thumbnails are kept in the database.

2) Yes and yes.

3) Yes, but only if the transfer was successful.

4) I just performed this action on my upgraded test forum which has about 70MB of attachments. The move was done in just a few seconds. Of course this time will vary with speed of your server.

[corsacrazy]

ok my friend ill let you know how it goes

[corsacrazy]

sorted, the url still points to

attachment.php?attachmentid=XXX

is that ok , as i was expecting

path/to/attachments/file.jpg ..... cheers

[conqsoft]

sorted, the url still points to

attachment.php?attachmentid=XXX

is that ok , as i was expecting

path/to/attachments/file.jpg ..... cheers

Yes, that's correct. That's how it handles who has permission to view attachments.

[corsacrazy]

Yes, that's correct. That's how it handles who has permission to view attachments.

cheers, one more thing

my stats in acp still state :

attachment Disk Usage 77.24 MB

But this one has gone up ....
Database Data Disk Usage

[Jake Bunce]

attachment Disk Usage 77.24 MB

That is correct. Your attachments are using 77.24 MB on disk (in the file system).

But this one has gone up ....
Database Data Disk Usage

That shouldn't be. The newly freed space might still need to be accounted for. Try running this:

Admin CP -> Import & Maintenance -> Repair / Optimize Tables

[corsacrazy]

thats the 1st thing i tried ^^ no luck, doesnt matter maybe stats are cashed?

ps cong see here

http://www.vbulletin.org/forum/showt...317#post491317

cheers jake

[Jake Bunce]

maybe stats are cashed?

Maybe, I'm not sure.

Do you have phpmyadmin installed so you can look at your table sizes through there?