Category Archives: Mariadb/Mysql

Remix WordPress Theme SLOW QUERY FIX

Remix WordPress Theme SLOW QUERY on Artists, Songs FIX The problem occurs when you have medium size database. Query to database can take up to 30s, for artists songs. The problem lies in /themes/remix/functions.php file more specific the related function which gives you all related songs/artists/lyrics/etc. This is the actual function:

Database query is interpeded like this:

As you can see from above pic it’s a sad sad situation:) We want to change that into this:

As you can see is an enormous improvement over this query. Here’s the updated function related(be awere that i didn’t need all post types, this is only for artists and songs, […]