Like Ra's Naughty Forum

Why? That would put enormous load on the DB.

(09 Dec 2017, 11:52 )Like Ra Wrote: [ -> ]Why? That would put enormous load on the DB.

Hmm You should give it a try... 
I don't see that much load on the DB. You may have to reconfig some DB parameters though.

Yes, that theoretically it's possible, but can you give me any reasons to do that? I know only downsides of it.

If you want to share your whole site via torrent this would be a much easier way to do it.

Again, why? 😉

You have thousands of pics spread over how many directories?
They are all named somehow, but in DB it is saved to which threat they belong to?
You want only to update "the new ones" for torrent... you dont want zip files...
Well, that all sounds like it fits best into a DB ( I speak fluently sql ... )

If you absolutely dont like that idea, maybe you have a look at rsync...

The directories are named after year and months, so not THAT many. All threads and file names are saved in the DB, but this is not an issue here. All what's needed is a script, that will check the file type, and copy the .attach files with the correct extensions to another directory.

Speaking of the DB. It's about 100MB in size, so it's fully cached in the memory. I'm trying to avoid any blobs and long text fields to prevent creating temp tables on the disk. And trying to decrease the amount of writes. There are too many. But this is for the technical thread.

(12 Dec 2017, 22:49 )Like Ra Wrote: [ -> ]The directories are named after year and months, so not THAT many. All threads and file names are saved in the DB, but this is not an issue here. All what's needed is a script, that will check the file type, and copy the .attach files with the correct extensions to another directory.

Well than take a closer look at rsync ....

I'm familiar with rsync, it will not help here. A simple check if the file is in the torrent place should do the trick 😉