111 reputation
2
bio website
location Lund, Sweden
age 26
visits member for 1 year, 5 months
seen Jul 24 at 10:10

Niklas Silfverström.

@silfverstrom

linkedin


Feb
26
awarded  Student
Feb
26
comment Problem with order by in MySQL subquery
@ThomasJones-Low I've previously tried running the query on a index (buyer_id, date_acquired, seller_id), ordering by date_acquired. Bad performance as well. However, the EXPLAIN said it was using "filesort"
Feb
26
comment Problem with order by in MySQL subquery
@AbdulManaf I've edited the question.
Feb
26
revised Problem with order by in MySQL subquery
added 855 characters in body
Feb
26
awarded  Editor
Feb
26
comment Problem with order by in MySQL subquery
Thomas, I've updated my question with the description of the tester index, and yes, date_sold is the first column.
Feb
26
revised Problem with order by in MySQL subquery
added 841 characters in body
Feb
26
asked Problem with order by in MySQL subquery