Re: How to use MySQL queries...?

>>And is there any effective way to calculate the statistics of comparison of >>query execution timings.. For query execution statistics, you need to log slow queries. To do so, enable following two directives in my.cnf file long_query_time = 2 log-slow-queries = /var/log/mysql/mysql_slow_query.log This configuration will log all queries that take more than 2 sec in the file /var/log/mysql/mysql_slow_query.log And monitor the logs. Parsing the logs from human eyes is bit trivial. You can user this http://www.mysqlperformanceblog.com/files/utils/mysql_slow_log_parser perl script to parse slow-queries. - Jignesh On Tue, Oct 7, 2008 at 10:24 AM, Richard Heyes <richard@php.net> wrote: > > Is there any big difference to use PROPEL or any other ORM mapping > > against basic > > functions provided by MySQL Extension...? > > If it's MySQL you're looking to optimise, then you could also try > asking on the MySQL discussion list. On the PHP side, the MySQL > functions are long-winded at best, try simple abstraction. This could > be as simple as using a small object or set of functions that does a > lot of the grunt work for, eg: > > $results = $db->getAll("SELECT * FROM mysql.user"); > > Much quicker to write than the equivalent using the PHP functions. > This does also make switching to another db far easier. > > -- > Richard Heyes > > HTML5 Graphing for FF, Chrome, Opera and Safari: > http://www.phpguru.org/RGraph > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >