strongability
注册会员
UID 97138
精华
0
积分 55
帖子 37
金钱 55 喜悦币
威望 0
人脉 0
阅读权限 20
注册 2007-8-17
状态 离线
|
如何保证效率
我看到一些用CMS的网站
首页有十几个小的版块让岂不是要抽数据库好多回
比如这样
<?php
15个小版块
$sqllink->result("SELECT * FROM `content` WHERE `content_tid` = '玩乐' limit 0,6");
while ($play_info_row=$sqllink->get_row()) {
$play_date=date('y.m.d',strtotime(trim($play_info_row[17])));
$play.="<li class=\"ul_menu_listnews\"><a href=\"read_list.php?id=$play_info_row[0]\">$play_info_row[12]</a><span>$play_date($play_info_row[16])</span></li>";
}
$sqllink->result("SELECT * FROM `content` WHERE `content_tid` = '吃喝' limit 0,6");
while ($eat_info_row=$sqllink->get_row()) {
$eat_date=date('y.m.d',strtotime(trim($eat_info_row[17])));
$eat.="<li class=\"ul_menu_listnews\"><a href=\"read_list.php?id=$eat_info_row[0]\">$eat_info_row[12]</a><span>$eat_date($eat_info_row[16])</span></li>";
}
$sqllink->result("SELECT * FROM `content_user` order by content_id desc limit 0,8");
while ($new_user_row=$sqllink->get_row()) {
$new_user.="<li>".trim($new_user_row[4])."</li>";
}
$sqllink->result("SELECT * FROM `content` order by content_hit desc limit 0,8");
while ($year_new_row=$sqllink->get_row()) {
$year_new.="<li><a href=\"read_list.php?id=$year_new_row[0]\">$year_new_row[12]</a></li>";
}
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '南渡' limit 0,6");
while ($site_nandu_row=$sqllink->get_row()) {
$site_nandu.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_nandu_row[0]\">$site_nandu_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '溧城镇' limit 0,6");
while ($site_lcz_row=$sqllink->get_row()) {
$site_lcz.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_lcz_row[0]\">$site_lcz_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '天目湖' limit 0,6");
while ($site_tmh_row=$sqllink->get_row()) {
$site_tmh.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_tmh_row[0]\">$site_tmh_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '周城' limit 0,6");
while ($site_zc_row=$sqllink->get_row()) {
$site_zc.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_zc_row[0]\">$site_zc_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '社渚' limit 0,6");
while ($site_sz_row=$sqllink->get_row()) {
$site_sz.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_sz_row[0]\">$site_sz_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '戴埠' limit 0,6");
while ($site_db_row=$sqllink->get_row()) {
$site_db.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_db_row[0]\">$site_db_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '上兴' limit 0,6");
while ($site_sx_row=$sqllink->get_row()) {
$site_sx.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_sx_row[0]\">$site_sx_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '上黄' limit 0,6");
while ($site_sh_row=$sqllink->get_row()) {
$site_sh.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_sh_row[0]\">$site_sh_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '竹箦' limit 0,6");
while ($site_zz_row=$sqllink->get_row()) {
$site_zz.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_zz_row[0]\">$site_zz_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '别桥' limit 0,6");
while ($site_bq_row=$sqllink->get_row()) {
$site_bq.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_bq_row[0]\">$site_bq_row[12]</a></li>"; }
$sqllink->result("SELECT * FROM `content` WHERE `content_sid` = '埭头' limit 0,6");
while ($site_dt_row=$sqllink->get_row()) {
$site_dt.="<li class=\"ul_menu_center\"><a href=\"read_list.php?id=$site_dt_row[0]\">$site_dt_row[12]</a></li>"; }
?> 这样的话还有什么效率呢
我看163的首页有几十个版块那岂不是更加没有效率 为什么他们的速度还是可以的呢
|
|
