Text only | Text with Images

Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: ltrace on October 27, 2013, 01:32:00 PM

Title: How many files in attachment folders is OK?
Post by: ltrace on October 27, 2013, 01:32:00 PM
Hi there, just get database error when trying to delete 4+ pages topic:
--
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay 

in ManageAttachments.php file
--
There was a limit in my.cnf
max_join_size = 1000000

changed size to 20 000 000 solved this issue for now

BUT - how many attachments is OK to store on 16 GB ram freebsd dedicated server?
Currently I have 28.000 photos + 28.000 thumbs (about 5 GB),

I understand "it depends.." but anybody have good experience runing 100k + attached photos on a single server without gallery mods?..
Title: Re: How many files in attachment folders is OK?
Post by: Arantor on October 27, 2013, 01:33:40 PM
When you get beyond a couple of thousand, you really should consider having multiple attachment folders, as supported by 2.0.

I would suggest no more than a couple of thousand files per folder.
Title: Re: How many files in attachment folders is OK?
Post by: ltrace on October 27, 2013, 01:46:12 PM
Thank a lot for your reply!,

so if I will create a new folder for 3000 - 5000 photos, can I feel myself safe to allow users upload more AND more, and more pics?... :)
Title: Re: How many files in attachment folders is OK?
Post by: Arantor on October 27, 2013, 01:49:01 PM
Yeah, if you create attachment folders like that, it should generally work better.
Text only | Text with Images