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.

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

Reply via email to