111 reputation
2
bio website
location Lund, Sweden
age 26
visits member for 1 year, 6 months
seen Aug 20 at 8:59

Niklas Silfverström.

@silfverstrom

linkedin


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