Advertisement:

Author Topic: How many files in attachment folders is OK?  (Read 729 times)

Offline ltrace

  • Newbie
  • *
  • Posts: 2
How many files in attachment folders is OK?
« 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?..

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,665
    • StoryBB/StoryBB on GitHub
Re: How many files in attachment folders is OK?
« Reply #1 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.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline ltrace

  • Newbie
  • *
  • Posts: 2
Re: How many files in attachment folders is OK?
« Reply #2 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?... :)

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,665
    • StoryBB/StoryBB on GitHub
Re: How many files in attachment folders is OK?
« Reply #3 on: October 27, 2013, 01:49:01 PM »
Yeah, if you create attachment folders like that, it should generally work better.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.