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