Re: Query Opinion

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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---