On Tue, Dec 30, 2008 at 1:07 PM, Robert Cummings <robert@xxxxxxxxxxxxx> wrote: > On Tue, 2008-12-30 at 12:53 -0500, Eric Butera wrote: >> On Tue, Dec 30, 2008 at 12:42 PM, Nathan Nobbe >> >> I was following the blog tutorial on cake and here's what I got from >> hitting the post/index page: >> >> 081230 12:51:55 316 Connect root@localhost on >> 316 Init DB cake >> 316 Query SHOW TABLES FROM `cake` >> 316 Query DESCRIBE `posts` >> 316 Query SELECT `Post`.`id`, `Post`.`title`, >> `Post`.`body`, `Post`.`created`, `Post`.`modified` FROM `posts` AS >> `Post` WHERE 1 = 1 >> 316 Quit > > A good framework will allow you to replace the introspection step with a > static definition of the database table, thus easily bypassing the extra > queries. Although, I can't fathom why they've requested all the tables. > > Cheers, > Rob. > -- > http://www.interjinn.com > Application and Templating Framework for PHP > To be fair cake did "cache" the show tables/describe magically for a few seconds if I sat there refreshing the page. :) I always generate my Gateways & VO's from table definitions & hand-code any non-crud statements. I've never really dealt with this stuff before but it is a little disheartening. I would rather take the 5 minutes re-generating a few files for an updated table versus infinite amounts of computer power wasted trying to just make it work. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php