我不确定是什么导致了这一点,因为我对查询数据库的PHP代码进行了一些基准测试,并据此调用查询和处理json发回的调用在0.001秒左右运行.

那么,这只是网络延迟吗？这是一个我没有正确进行数据库查询的问题吗？也许我充斥着每个浏览器窗口的最大连接数？不知道.其他请求的移动速度一样慢,所以看起来它可能是一致的.

这是其余请求计时的另一张照片(其他主要的ajax调用与get_usergames_simple调用的时间一样多：

作为参考,这里是ajax调用：

self.getGamesContent = function()
{
  var userID = "<?PHP echo $userID; ?>";

  var post_data = {
    userID: userID
  };

  $.post("https://mydomain.com/games/get_usergames_simple/",post_data,function(result)
  {
    var json = $.parseJSON(result);

    var mappedGames = $.map(json.games,function(item) {
      return new GameItem(item)
    });
    self.gameitems(mappedGames);
  });
};

这是运行查询的控制器中的PHP代码：

$userID = $this->input->post('userID');
$this->benchmark->mark('code_start');

$userGames = $this->cache->model('games','getGamesSimpleByUserID',array($userID),120); // keep for 2 minutes

$returnString = "{";

$returnString .= '"user_id": "' . $userID . '",';

$gameCount = 0;

$returnString .= '"games": [';
foreach ($userGames as $ug)
{
  $returnString .= "{";
  $returnString .= '"user_id" : "' . $userID . '",';
  $returnString .= '"game_id" : "' . $ug->GameID . '",';
  $returnString .= '"game_name" : "' . $ug->GameName . '",';
  $returnString .= '"game_image" : "' . $ug->GameImage . '",';
  $returnString .= '"description" : "' . htmlspecialchars($ug->GameDescription) . '",';
  $returnString .= '"genre_id" : "' . $ug->GameGenreCatID . '",';
  $returnString .= '"genre_name" : "' . $ug->GameGenreName . '",';
  $returnString .= '"publisher_id" : "' . $ug->GamePublisherID . '",';
  $returnString .= '"publisher_name" : "' . $ug->GamePublisherName . '",';
  $returnString .= '"developer_id" : "' . $ug->GameDeveloperID . '",';
  $returnString .= '"developer_name" : "' . $ug->GameDeveloperName . '",';
  $returnString .= '"active_flag" : "' . $ug->GameIsActive . '",';
  $returnString .= '"create_date" : "' . $ug->GameCreateDate . '",';
  $returnString .= '"remove_date" : "' . $ug->GameRemoveDate . '",';
  $returnString .= '"last_update_date" : "' . $ug->GameLastUpdateDate . '",';
  $returnString .= '"user_syncing_game" : "' . $ug->UserSyncingGame . '"';
  $returnString .= "},";
  $gameCount++;
}

if ($gameCount > 0)
  $returnString = substr($returnString,strlen($returnString) - 1);

$returnString .= "]}";


$this->benchmark->mark('code_end');

//echo $this->benchmark->elapsed_time('code_start','code_end');

echo $returnString;