Have to checked how long that final query takes?
Depending on the number of torrents, the indexes on the torrents table, the database engine and the amount or ram allotted to mysql, it could take several minutes to run.
If you are using MyISAM then the entire torrents table is locked while this query runs and everything else waits. If you are using InnoDB then only the rows being updated are locked. Could be a significant difference there.
|