The first thing I see, do you need all of the fields in your "SELECT *" statement?
Jeff Oien wrote: > Here is some code I have for an index page of people who post > charts on the Web, kind of like Yahoo Photos or something. > It displays the album title, number of images and date of last > upload. The page takes about 5-6 seconds to load which is all > in the queries I'm sure. Is there a way I can make this more efficient? > http://www.webdesigns1.com/temp/code.txt > Jeff > > -------------------------------------- > > $table_name = "Chart_Users"; > $sql = "SELECT * FROM $table_name order by album_title"; > $result = @mysql_query($sql,$connection) or die(" Couldn't execute query."); > //if(! $result = mysql_query($sql,$connection)) { > // print("ERROR ".mysql_errno().": >".mysql_error()."<br>\n$sql<br>\n"); > // } > > while ($row = mysql_fetch_array($result)) { > $id = $row['id']; > $username = $row['username']; > $title1 = $row['album_title']; > $title = stripslashes($title1); > > $sql1 = "SELECT COUNT(*) FROM Chart_Files where id = '$id'"; > $result1 = @mysql_query($sql1,$connection) or die(" Couldn't execute >query."); > //if(! $result = mysql_query($sql1,$connection)) { > //print("ERROR ".mysql_errno().": ".mysql_error()."<br>\n$sql<br>\n"); > //} > $count = mysql_result($result1,0,"count(*)"); > > $sql2 = "SELECT date_format(date, '%b. %D, %Y') as >date1 FROM Chart_Files where > id = '$id' order by photoid desc limit 1"; > $result2 = @mysql_query($sql2,$connection) or die(" >Couldn't execute query."); > $row = mysql_fetch_array($result2); > $date1 = $row['date1']; > > if ($count > 0) { > > $display_block .= "<tr><td nowrap align=\"left\"><b><a > href=\"display_album.php?id=$id\">$title </a></b></td><td > align=\"left\">$count</td><td align=\"right\" nowrap>$date1</td></tr>"; > } > } > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
