I've noticed that even in production mode, every single page load requires a describe call to the database (information schema) for each Model involved. I'm currently using v1.2.0.5427alpha with PostgreSQL and can verify the calls on each page by running postgres in log all mode:
LOG: statement: 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 ='accounts' ORDER BY position LOG: statement: 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 ='clients' ORDER BY position This ends up being considerable unnecessary overhead, but I can't find any supported way to ensure the table data is cached. I'd like to see if there is an official way to do this before I hack around it. Any ideas? Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
