Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Richard Thomas' Blog:
Solar Framework Shorts - Basic Sql Profiling
Nov 09, 2009 @ 09:40:20

Richard Thomas has posted another "Solar Framework Short" for the Solar PHP framework today - this time it's a simple example of setting up SQL profiling.

He includes a code sample that sets up a database object with a custom configuration and calls the "setProfiling" method on it, giving it a value of "TRUE".

This prints out a lovely array with all the queries that have been done. Why is this really useful? Because when using ORM/Model systems the framework builds your queries for you.. This allows you to dig a little deeper, see whats going on, how the queries are being built and were you might need indexes and other changes.
tagged: solar framework sql profile tutorial