RE: [PHP-DB] Re: SQL or array ?

Hi, I'd just like to point out that one important option was overlooked: You could create a SQL query which would read the folders AND the mimetype/icon info at the same time. This means that you can have your database do most of the work for you which normally means it's faster. Rgds, Jos -----Original Message----- From: Simon Rees [mailto:tech-lists@zodiac2000.co.uk] Sent: 24 April 2005 18:52 To: php-db@lists.php.net Cc: Paul Reilly Subject: Re: [PHP-DB] Re: SQL or array ? On Sunday 24 April 2005 12:25, Paul Reilly wrote: > How would I go about benchmarking the different options? > What tools are there to do this? a) time the script - quick, dirty and inaccurate but may provide an indicative result. b) use a profiler, which can be more interesting as it will show the CPU time taken by various parts of the script. I've used Xdebug for profiling and found it useful. Have a look at http://www.php.net/debugger for this and other options (I assume the other debuggers have profiling support). Simon -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Simon Rees  |  tech-lists@zodiac2000.co.uk  | ORA-03113: end-of-file on communication channel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php