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@xxxxxxxxxxxxxxxx] Sent: 24 April 2005 18:52 To: php-db@xxxxxxxxxxxxx Cc: Paul Reilly Subject: Re: 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@xxxxxxxxxxxxxxxx | 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
