MySQL Forums
Forum List  »  Performance

Re: Utilize maximum system resources for better performance
Posted by: Rick James
Date: August 09, 2015 03:53PM

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

Options: ReplyQuote

Written By
Re: Utilize maximum system resources for better performance
August 09, 2015 03:53PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.