+- Like Ra's Naughty Forum (https://www.likera.com/forum/mybb)
+-- Forum: Technical section (https://www.likera.com/forum/mybb/Forum-Technical-section)
+--- Forum: Site (https://www.likera.com/forum/mybb/Forum-Site)
+--- Thread: LikeRa.Com siterip torrent and RetroShare collection (/Thread-LikeRa-Com-siterip-torrent-and-RetroShare-collection)
RE: Poll: entire website torrent - Like Ra - 09 Dec 2017
Why? That would put enormous load on the DB.
RE: Poll: entire website torrent - krinlyc - 09 Dec 2017
(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.
RE: Poll: entire website torrent - Like Ra - 10 Dec 2017
Yes, that theoretically it's possible, but can you give me any reasons to do that? I know only downsides of it.
RE: Poll: entire website torrent - krinlyc - 11 Dec 2017
If you want to share your whole site via torrent this would be a much easier way to do it.
RE: Poll: entire website torrent - Like Ra - 11 Dec 2017
Again, why? 😉
RE: Poll: entire website torrent - krinlyc - 12 Dec 2017
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...
RE: Poll: entire website torrent - Like Ra - 12 Dec 2017
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.
RE: Poll: entire website torrent - Like Ra - 12 Dec 2017
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.
RE: Poll: entire website torrent - krinlyc - 13 Dec 2017
(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 ....
RE: Poll: entire website torrent - Like Ra - 13 Dec 2017
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 😉