Re: Using USE INDEX or FORCE INDEX in Model->find & relationships

Thanks for the reply. That's give me something to think about.

I've not used finderQuery before, I'll certainly give it some time.

Thanks again.

On Nov 27, 12:20 am, cricket <zijn.digi...@gmail.com> wrote:
> On Fri, Nov 26, 2010 at 12:03 PM, kadanis <evad.ba...@gmail.com> wrote:
> > Just wondering if anyone has any suggestions on this.
>
> > I'm using Cake for a current project and the project lead is insisting
> > we use FORCE INDEX on the queries and table joins.
>
> > I've searched all over the web and come up empty handed so far and
> > don't particularly want to hand code all the sql queries in Model-
> >>query().
>
> > I have looked at the core and managed to hack it to get the desired
> > results, but its a nasty hack and not sustainable through upgrades of
> > the Cake core code.
>
> > Anyone have any suggestions, they would be greatly appreciated!
>
> I suspect that you could use a finderQuery for this. Unfortunately,
> it's poorly documented (no surprise). Search for "cakephp
> finderquery".
>
> And ask your project lead if he/she has seen this:http://www.mysqldiary.com/the-battle-between-force-index-and-the-quer...

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

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