How many files in attachment folders is OK?

[ltrace]

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?..

[Arantor]

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.

[ltrace]

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?...

[Arantor]

Yeah, if you create attachment folders like that, it should generally work better.