I'm running into peformance issues with the findCount() method in the model class..
I am doing a listing of records in a given table, and the record has a few associations for it, however the table that I am querying has 1.8 million records in it, and while I turn off the recursive option in findAll() (which keeps my query time down to 17ms), the findCount() method still LEFT JOINs the 3 other association tables when simply doing a count(*) operation, and this gives me a 16000ms execution time on the findCount() method. Is there a way to tell findCount() that I don't care about the associations, much like I can with findAll()? I suppose I can override it, but this seems like something that should be in the model class, no? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
