-Original Message-
From: Simon Rees [mailto:[EMAIL PROTECTED]
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
Okay, thanks all.
I think what I'll do is save the data in a DB, and then read it in
to an array when the script is first called. That way it doesn't need
to perform the SQL query per mime_type hundreds of times, and can just
key it from the array.
How would I go about benchmarking the
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
Paul,
Interesting - I don't know which would give better performance, there
are too many things I don't know about your set up but here are some
general rules I think would apply:
How many files are we talking about? If it's many I think a database
is the only way to go.
What happens when