MySql: make this query faster… is there a way ? PART TWO
Posted
by robert
on Stack Overflow
See other posts from Stack Overflow
or by robert
Published on 2010-05-26T15:04:27Z
Indexed on
2010/05/26
15:21 UTC
Read the original article
Hit count: 117
This is part two of the question: http://stackoverflow.com/questions/2913639/mysql-make-this-query-faster-theres-a-way
this query still run slowly:
SELECT b.id,
b.name,
c.name
FROM bookcorr as a JOIN books as b on b.id = a.books_id =
JOIN Library as c on c.id = a.library_id
WHERE a.category_id = '2521'
AND a.library_id = '4983'
ORDER BY b.name ASC LIMIT 0,15
Any suggest ?
© Stack Overflow or respective owner