Re: DESCRIBE happening too often
All that describes (and other stuff) are chached in debug level 0, so
check yur app/config/core.php settings and by the way reading the
manual (http:://manual.cakephp.org) doesn't hurt.
On Fri, Aug 29, 2008 at 3:54 PM, cmbg [EMAIL PROTECTED] wrote:
Hi all --
I have tried to manually define the schema in the models -- i.e.,
class MyModel extends AppModel {
var $name = 'MyModel ';
var $_schema = array(
'id'= array('type' = 'integer', 'null' = '', 'default' =
'1',
'length' = '8', 'key'='primary'),
'name'=array('type'='string', 'null'='', 'default'='',
'length'='50'),
'created'= array('type' = 'date', 'null' = '1', 'default'
= '',
'length' = ''),
'modified'= array('type' = 'datetime', 'null' = '1',
'default' =
'', 'length' = null)
);
}
but every page view always brings up first the auth tables (aros,
acos, aros_acos) and then every table that I use in the controller
even if the view isn't requiring that table... in some cases up to 20+
tables. My DBA doesn't like this at all performance wise. I've
looked at the bakery and other cakephp docs but haven't found an
answer and I'd really like to stop this from happening...
Thanks,
bg
-- Forwarded message --
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Dec 18 2007, 2:56 am
Subject: DESCRIBE happening too often
To: CakePHP
As far as I know, the describe should not occur if there is is a
schema defined for the database tables. The new console in 1.2 should
generate this automatically when you create a new model with 'cake
bake'. I haven't tried it yet cause i can't find those bloody minutes
but i can't postpone it much longer. If you do happen to find a
solution until then please let me know too. I would appreciate it.
Thanks,
Cristian
On Dec 16, 5:26 am, Olexandr Melnyk [EMAIL PROTECTED] wrote:
SHOW PROCESSLIST
On 12/14/07, Grant Cox [EMAIL PROTECTED] wrote:
How are you checking that you are getting a lot of DESCRIBE queries
with DEBUG set to 0?
On Dec 14, 7:09 am, Olexandr Melnyk [EMAIL PROTECTED] wrote:
Hello bakers,
in one of applications I'm working on, I have noticed DESCRIBE queries
being
executed on every page for all used models. With a load of page views,
this
only creates problems.
As far as I know, such queries should be cached if
application is in production (DEBUG = 0), but I still get them quite
often. I have cheched /app/tmp/ directory permissions, and they are set
to 777.
I am using CakePHP 1.1
I don't know if CakePHP's cache expires after a number of pageviews
since
last update or after a set
period of time, but is there a way to extend its lifetime?
Thanks
--
Sincerely yours,
Olexandr Melnyk http://omelnyk.net/
--
Sincerely yours,
Olexandr Melnykhttp://omelnyk.net/
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Fwd: DESCRIBE happening too often
Hi all --
I have tried to manually define the schema in the models -- i.e.,
class MyModel extends AppModel {
var $name = 'MyModel ';
var $_schema = array(
'id'= array('type' = 'integer', 'null' = '', 'default' =
'1',
'length' = '8', 'key'='primary'),
'name'=array('type'='string', 'null'='', 'default'='',
'length'='50'),
'created'= array('type' = 'date', 'null' = '1', 'default' =
'',
'length' = ''),
'modified'= array('type' = 'datetime', 'null' = '1',
'default' =
'', 'length' = null)
);
}
but every page view always brings up first the auth tables (aros,
acos, aros_acos) and then every table that I use in the controller
even if the view isn't requiring that table... in some cases up to 20+
tables. My DBA doesn't like this at all performance wise. I've
looked at the bakery and other cakephp docs but haven't found an
answer and I'd really like to stop this from happening...
Thanks,
bg
-- Forwarded message --
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Dec 18 2007, 2:56 am
Subject: DESCRIBE happening too often
To: CakePHP
As far as I know, the describe should not occur if there is is a
schema defined for the database tables. The new console in 1.2 should
generate this automatically when you create a new model with 'cake
bake'. I haven't tried it yet cause i can't find those bloody minutes
but i can't postpone it much longer. If you do happen to find a
solution until then please let me know too. I would appreciate it.
Thanks,
Cristian
On Dec 16, 5:26 am, Olexandr Melnyk [EMAIL PROTECTED] wrote:
SHOW PROCESSLIST
On 12/14/07, Grant Cox [EMAIL PROTECTED] wrote:
How are you checking that you are getting a lot of DESCRIBE queries
with DEBUG set to 0?
On Dec 14, 7:09 am, Olexandr Melnyk [EMAIL PROTECTED] wrote:
Hello bakers,
in one of applications I'm working on, I have noticed DESCRIBE queries
being
executed on every page for all used models. With a load of page views,
this
only creates problems.
As far as I know, such queries should be cached if
application is in production (DEBUG = 0), but I still get them quite
often. I have cheched /app/tmp/ directory permissions, and they are set
to 777.
I am using CakePHP 1.1
I don't know if CakePHP's cache expires after a number of pageviews
since
last update or after a set
period of time, but is there a way to extend its lifetime?
Thanks
--
Sincerely yours,
Olexandr Melnyk http://omelnyk.net/
--
Sincerely yours,
Olexandr Melnykhttp://omelnyk.net/
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: DESCRIBE happening too often
SHOW PROCESSLIST On 12/14/07, Grant Cox [EMAIL PROTECTED] wrote: How are you checking that you are getting a lot of DESCRIBE queries with DEBUG set to 0? On Dec 14, 7:09 am, Olexandr Melnyk [EMAIL PROTECTED] wrote: Hello bakers, in one of applications I'm working on, I have noticed DESCRIBE queries being executed on every page for all used models. With a load of page views, this only creates problems. As far as I know, such queries should be cached if application is in production (DEBUG = 0), but I still get them quite often. I have cheched /app/tmp/ directory permissions, and they are set to 777. I am using CakePHP 1.1 I don't know if CakePHP's cache expires after a number of pageviews since last update or after a set period of time, but is there a way to extend its lifetime? Thanks -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
DESCRIBE happening too often
Hello bakers, in one of applications I'm working on, I have noticed DESCRIBE queries being executed on every page for all used models. With a load of page views, this only creates problems. As far as I know, such queries should be cached if application is in production (DEBUG = 0), but I still get them quite often. I have cheched /app/tmp/ directory permissions, and they are set to 777. I am using CakePHP 1.1 I don't know if CakePHP's cache expires after a number of pageviews since last update or after a set period of time, but is there a way to extend its lifetime? Thanks -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: DESCRIBE happening too often
How are you checking that you are getting a lot of DESCRIBE queries with DEBUG set to 0? On Dec 14, 7:09 am, Olexandr Melnyk [EMAIL PROTECTED] wrote: Hello bakers, in one of applications I'm working on, I have noticed DESCRIBE queries being executed on every page for all used models. With a load of page views, this only creates problems. As far as I know, such queries should be cached if application is in production (DEBUG = 0), but I still get them quite often. I have cheched /app/tmp/ directory permissions, and they are set to 777. I am using CakePHP 1.1 I don't know if CakePHP's cache expires after a number of pageviews since last update or after a set period of time, but is there a way to extend its lifetime? Thanks -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
