从'；视图'；导致PHP和SQL Server中的执行超时 - Select from 'view' causing execution timeout in PHP and SQL Server

Select from 'view' causing execution timeout in PHP and SQL Server

我创建了一个名为view的stats，用于选择符合特定属性的记录的总和

CREATE VIEW stats
AS
SELECT
    SUM(CASE WHEN attribute = '1' THEN 1 ELSE 0 END) AS attribute1,
    SUM(CASE WHEN attribute = '2' THEN 1 ELSE 0 END) AS attribute2
FROM table
GO

视图创建得很好，当我在SQLServerManagementStudio中说SELECT * FROM stats时，结果显示得很好。

问题是当我使用PHP获取数据时：

$GRAB_STATS_DATA = $DBH->query("SELECT * FROM stats");
while($row = $GRAB_STATS_DATA->fetch()){
    $attribute1 = $row['attribute1'];
    ... // and so on
}

我在说[PHP Fatal error: Maximum execution time of 300 seconds exceeded in C:' ... on line 17] 时出错

为什么使用PHP的上述超时（或执行时间超过300秒）在SQLServerManagementStudio中显示良好？

使用：

foreach ($GRAB_STATS_DATA->fetchAll() as $row){
  $attribute1 = $row['attribute1'];
    ... // and so on
}