MySQL Forums
Forum List  »  General

Bad performance for specific user
Posted by: Jonathan Selander
Date: September 15, 2008 05:09AM

Hi,

I'm creating a database API thingy to give users restricted access to view and modify data. I have created a special database to hold the views/update functions, and these manipulate/access data in tables in other databases.

Access-wise this works. Users can't access the actual tables in the other databases, but the views present correct data. However, when I run "SELECT * FROM view" as an under-privileged user, the query takes ~3,33 seconds, while if I run it as root, it takes 0.05 seconds.

I read something about view restrictions concerning indexes, but shouldn't this affect root as well?

Is there something that root can access but the other users can't, that can be the cause of the bad performance?

I used the MERGE algorithm.

Options: ReplyQuote


Subject
Written By
Posted
Bad performance for specific user
September 15, 2008 05:09AM


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.