In my experience with Oracle technology, the best performance is
always to minimize the number of queries, so if you can grab it all in
one query, that would be best!
Enjoy,
John
On Jul 27, 5:22 am, Dave Maharaj :: WidePixels.com
d...@widepixels.com wrote:
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+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---