Re: DESCRIBE happening too often

[Dardo Sordi Bogado]

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

[cmbg]

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

[[EMAIL PROTECTED]]

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 <>
> --
> Sincerely yours,
> Olexandr Melnykhttp://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

[Olexandr Melnyk]

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 <> >
>


-- 
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

[Grant Cox]

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 <>

DESCRIBE happening too often

[Olexandr Melnyk]

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
-~--~~~~--~~--~--~---