Re: Utilize maximum system resources for better performance

[Rick James]

> SELECT * FROM content WHERE enabled = 1 ORDER BY seeders DESC , upload_date DESC LIMIT 0,25

Needs INDEX(enabled, seeders, upload_date)

> create a new table, load data in this table, then take inserted values and update those in main table.

Yes, the _might_ be more efficient than the 21.xx minute process now.

As for your link to the stackoverflow thread... That sounds similar, but it failed to give much of an answer...

Three things _could_ be happening; which ones apply?
* New rows are being loaded
* Existing rows are being updated with changed values
* Some existing rows need to be deleted.

Assuming you only need to deal with "new" and "changed" rows, see my 'Answer' (just now posted) to that stackoverflow thread.