我想知道,哪些代码在thory需要更长的时间:时间复杂度从MySQL数据库中读取
1.
$query = "SELECT Something1, Something2 FROM base WHERE SomeCondition";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
//We do something with $row[0] and row[1]
}
2.
$query = "SELECT Something1 FROM base WHERE SomeCondition";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
//We do something with $row[0]
}
$query = "SELECT Something2 FROM base WHERE SomeCondition";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
//We do something with $row[0]
}
现在1.应更快,因为虽然统计以O(n)时间执行,而另一个以O(2 * n)执行,但是第一个必须一次查询两列,而在2中必须查询一列列,但两次。现在我想知道一次一列或两列一次性的mysql_query和mysql_fetch_array性能如何?