please correct me if im wrong but the query which im having a problem with is a query called by cake once a model is used.
regards, Gin On Jul 10, 3:25 pm, jeff <[email protected]> wrote: > 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-... > > 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 -~----------~----~----~----~------~----~------~--~---
