Order by in derived table slow

Hi guys,

I'm not sure what's going on with the order by.

The order by name below takes .14 seconds. Without it, it takes .0054 seconds.

An order by name without the join takes .00036 seconds
The join without the order by name takes .005 seconds

Why does it take .14 combined, what am i missing?

Thanks

 

Anybody have any ideas on this issue?

 

Hi sc_king

Do you have Index on stars.name?
Creating this Index can speed up the query, but no more than

Regards,
Nick

 

Hey Koko,

Thanks for the reply.

It takes the same amount of time on all the fields.

Even if I order by id and that's the primary key.

Thanks