One search or lots of little sqls?

From: 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

« previous php.db (#18329) next »