The unbindModel() model function allows you to remove the queries u dont
want...
$this->unbindModel(array('hasAndBelongsToMany'=>array('Tag')));
or use this link
http://book.cakephp.org/view/86/Creating-and-Destroying-Associations-on-the-Fly
i think this might help
On Fri, Jul 10, 2009 at 12:03 PM, gin <[email protected]> wrote:
>
> hi, Im having a problem with the slow loading of my pages. This is
> caused by the query
>
> "SELECT DISTINCT column_name AS name, data_type AS type, is_nullable
> AS null,
> column_default AS default,
> ordinal_position AS position,
> character_maximum_length AS char_length,
> character_octet_length AS oct_length
> FROM
> information_schema.columns
> WHERE table_name = " . $this->value($table)
> . " AND table_schema =
> " .
> $this->value($this->config['schema'])."
> ORDER BY position"
>
> which is called by cake everytime a page loads.. i am working with a
> large database which creates new tables daily. This query called by
> cake makes my page load in more than a minute which is unacceptable
> for a simple login page that i have. Has anyone have a resolve for
> this? thank you very much.
>
> >
>
--
--
(¨`•.•´¨) I may be busy,
`•.¸(¨`•.•´¨) but I assure you,
(¨`•.•´¨)¸.•´ you are always in my heart
`•.¸.•´
With Lots of Love.....
THANKS AND REGARDS
Jeffery Jacob
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
