RE: Re: SQL or array ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux