MySQL Forums
Forum List  »  Performance

Optimization for complicated query
Posted by: Paulo Torrens
Date: August 01, 2012 11:34AM

Hi!

I currently have the following query to perform:

select
camera.id, camera.host, camera.port, camera.name,
AES_DECRYPT(camera.pass, "$secret"), camera.stream,
camera.model
from
camera, user, account, model, cameramodel
where
camera.user = account.user = user.id = $MY_USER_ID and
account.security_key = $MY_SECURITY_KEY and
account.access_lvl >= camera.access_lvl and
camera.model = model.id and
cameramodel.model = model.id
;

I am still not having problems with it, but I got the sense it I may have shortly soon. How could I possibly improve and optimize this?


Thank you!

Options: ReplyQuote


Subject
Views
Written By
Posted
Optimization for complicated query
1812
August 01, 2012 11:34AM
1000
August 02, 2012 02:17AM
1004
August 02, 2012 11:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.