One search or lots of little sqls?
| From: | John Hughes | Date: | Mon, 08 Apr 2002 22:52:22 +0000 |
| Subject: | One search or lots of little sqls? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18329@lists.php.net to get a copy of this message | ||
I'm building a site that will eventually hold several hundred photos. (Kids
soccer photos.) The first page will display a table of 9 thumbnails, with
buttons at the bottom to move 9 forward or 9 back (after the first 9, of
course).
The names of the files will be in a MySQL database and the pages built in
PHP. (This should satisfy the topic-sensitive on this list.)
Would it be better to:
Gather all of the names in one PHP array, thus having only one MySQL call,
and pass that array as a hidden value using $PHP_SELF
Or would it be better to have the page pull the data using LIMIT to pick the
portion to display?
We are not talking a high-volume site, perhaps a dozen people at one time.
John Hughes