Re: Too many count statements

You should probably also post all your CakePHP code around the queries you run

We are not mind readers after all

Am Freitag, 16. Mai 2014 11:06:57 UTC+2 schrieb heohni:

Hi,

I am just reading in a json string, use json_decode() to get an array and then I walk through this array and do an update statement.

Really simple stuff, but in debug mode I can see for each array element the following statements:

1	SELECT COUNT(*) AS `count` FROM `tablex`.`data` AS `fieldy` WHERE `data`.`id` = 17
2	SELECT COUNT(*) AS `count` FROM `tablex`.`data` AS `fieldy` WHERE `data`.`id` = 17
3	SELECT COUNT(*) AS `count` FROM `tablex`.`data` AS `fieldy` WHERE `data`.`id` = 17
4	UPDATE `tablex`.`data` SET `player_id` = 43, `timeout` = '0', `answer` = '', `value` = '', `points` = '', `modified` = '2014-05-16 10:56:36' WHERE `tablex`.`data`.`id` = 17

Why do I get so many count statements?

How can I avoid / improve this?

Thanks!

Heidi

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.