If you have alot of RAM then use MEMORY storage engine for peers, guests tables, and INNODB for users, torrents.
With abit of traffic your site will become heavilly overloaded, the main problem is the scrape/announce requests.
In the past i did some experimental work with adding caching in the announce/scrape and it helped alot.
|