Oops, my previous comment was incorrect. taking off validation does not prevent the double count from happening. The second one is called none the less.
On Sep 11, 2:15 pm, Wilhelm <[email protected]> wrote: > Hi, > > thanks for your response, I will make sure that MySql cache is > enabled. I have also done some research into this ( I took some time > to look through the model code ) > and found that if you disable validation, the second Count query will > not occur. > > Kind Regards > Wilhelm > > On Sep 11, 12:45 am, francky06l <[email protected]> wrote: > > > Well, that's the way cake's handles it ... Now if you have the query > > cache enabled on MySql, the second COUNT should cost 0 .. > > You can try using updateAll ... that should not make extra query .. > > > On Sep 10, 3:10 pm, Wilhelm <[email protected]> wrote: > > > > Hi, > > > > I would like to first of all apologize if this has been answered > > > before by all my searching I could not find out, ( possible google > > > skills lacking ) > > > > So I am busy running CakePHP 1.3.3 and noticed something a little > > > strange when performing a update. Looking at the run queries I have > > > noticed that there are two Select Count(*) queries. Do some research I > > > did find out that there is a reason for the one to have better error > > > detection but I think the second one is a little excessive. I have > > > stopped short of reporting this as a bug as I would would first like > > > to check that I am not missing something in my implementation. > > > > The php script > > > $this->Campaign->Mo->id = $moId; > > > $this->Campaign->Mo->save( array( 'Mo' => > > > array( 'field_one'=>1,'field_two'=>2 ) ) ); > > > > Debug Report > > > SELECT COUNT(*) AS `count` FROM `mos` AS `Mo` WHERE `Mo`.`id` = 91 > > > SELECT COUNT(*) AS `count` FROM `mos` AS `Mo` WHERE `Mo`.`id` = 91 > > > UPDATE `mos` SET `field_one` = 1, `field_two` = 2, `modified` = > > > '2010-09-10 12:56:28' WHERE `mos`.`id` = 91 > > > > Any help will greatly be appreciated. > > > > Kind Regards > > > Wilhelm 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 [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
