Query Opinion

I am building a function that checks access permission. First check if profile is public, if not conditions from 2 other tables are checked and 1 of those conditions must be true to allow access.

 

My question is should i just grab all the conditions needed to be checked with 1 query then compare the values i need to check  then check the values returning true or false or do them 1 at a time....

 

So if not public run a query to check the next condition, if that returns false run the final query?

 

Just wondering what the best way would be.

 

Opinion?

 

thanks

 

Dave

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---