LikeRa.Com siterip torrent and RetroShare collection

[Like Ra]

Why? That would put enormous load on the DB.

[krinlyc]

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.

[Like Ra]

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

[krinlyc]

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

[Like Ra]

Again, why? 😉

[krinlyc]

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

[Like Ra]

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.

[Like Ra]

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.

[krinlyc]

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

[Like Ra]

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 😉