blocks|key|2249743|text|您可以使用Insert+into+values("1"，"2"，"3")，("3"，"5，"5")|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2249744|在foreach中，您可以创建一个值数组，在forloop之外，您可以内爆并插入到mysql中。|2249745|比方说|2249746|$values+=+array();
foreach($yourData+as+$eachData){

//+prepare+your+values+here.
$values[]+=+"('1','2',3')";

}


//+out+of+forloop,
$values+=+implode(",",$values);+

$query+=+"+insert+into+`tablename`+(field1,field2,field2)+values+{$values}+"+;|code-block|syntax|javascript|2249747|干杯|2249748|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

you can use Insert into values("1","2","3"),("3","5,"5")

in foreach, you can create an array of values and out of forloop you can implode and insert into mysql.

Lets say,

<pre><code>$values = array();
foreach($yourData as $eachData){

// prepare your values here.
$values[] = "('1','2',3')";

}


// out of forloop,
$values = implode(",",$values); 

$query = " insert into `tablename` (field1,field2,field2) values {$values} " ;
</code></pre>

Cheers

blocks|key|1357359|text|是的，当涉及到查询的数量时，通常是最小的是性能。但是，您的脚本受到网络io(下载速度)的限制，而不是数据库。当操作系统下载数据时，您的脚本大部分时间都处于睡眠状态。正因为如此，您发出的任何查询都将相对较少。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1357360|我的建议是让它正常工作。|1357361|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

yes, generally being minimal when it comes to the number of querys is performant. But, your script is limited by network io(download speed), not the database. Your script will be asleep most of the time while the os downloads the data. Any queries you issue would be relatively infrequent because of that.

my advice is to just get it working.

blocks|key|611103|text|如前所述，您可以用一个查询插入多个行，这比对每行使用单独的查询要优化得多。您可以使用循环向查询字符串中添加更多行，但最重要的是，记住对数据进行转义！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|611104|<?php++++
$rows+=+array();
$sql+=+'
++++INSERT+INTO+`table`+(`key`,+`data`)
++++VALUES+';

$data+=+array(
++++array(
++++++++'key'+=>+'key1',
++++++++'value'+=>+'some+value'
++++),
++++array(
++++++++'key'+=>+'key2',
++++++++'value'+=>+'some+value+2'
++++),
++++array(
++++++++'key'+=>+'key3',
++++++++'value'+=>+'some+value+3'
++++),
);

for+($i+=+0;+$i+<+count($data);+%2B%2B$i)
{
++++//+Do+me+a+favor+and+look+up+PDO.
++++$key+=+mysql_escape_string($data[$i]['key']);
++++$row+=+mysql_escape_string($data[$i]['value']);

++++if+($i+===+0)
++++++++$sql+.=+'+(\''+.+$key+.+'\',+\''+.+$row+.+'\')';
++++else
++++++++$sql+.=+',+(\''+.+$key+.+'\',+\''+.+$row+.+'\')';
}|code-block|syntax|javascript|611105|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

As previously stated, you can insert multiple rows with one query, which is much more optimized than using a separate query for each row. You can add more rows to the query string with a loop, but above all, remember to escape the data!

<pre><code>&lt;?php 
$rows = array();
$sql = '
 INSERT INTO `table` (`key`, `data`)
 VALUES ';

$data = array(
 array(
 'key' =&gt; 'key1',
 'value' =&gt; 'some value'
 ),
 array(
 'key' =&gt; 'key2',
 'value' =&gt; 'some value 2'
 ),
 array(
 'key' =&gt; 'key3',
 'value' =&gt; 'some value 3'
 ),
);

for ($i = 0; $i &lt; count($data); ++$i)
{
 // Do me a favor and look up PDO.
 $key = mysql_escape_string($data[$i]['key']);
 $row = mysql_escape_string($data[$i]['value']);

 if ($i === 0)
 $sql .= ' (\'' . $key . '\', \'' . $row . '\')';
 else
 $sql .= ', (\'' . $key . '\', \'' . $row . '\')';
}
</code></pre>

I'm writing a PHP script to scrape data from the web. End-result, I want to have all the scraped data tucked and formatted nicely in a mysql database.

But as there are multiple loops and arrays to iterate through within the PHP script, my gut feeling is that for speed and efficiency, it would be best NOT to keep loop-cycling access to the mysql database (inserting data on each go-around of the loops) -- instead, storing the data in temporary arrays within PHP, and then only at the end of the script, dumping the arrays into mysql in one go.

What say ye?

When iterating through loops, is it more/less efficient to access a MySQL within loop?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在编写一个PHP脚本来从web上抓取数据。最终，我想要把所有抓取的数据很好地塞进mysql数据库中并进行格式化。但是，由于PHP脚本中有多个循环和数组需要迭代，我的直觉是，为了速度和效率，最好不要保持对mysql数据库的循环访问(在每次循环时插入数据)，而是将数据存储在PHP中的临时数组中，然后仅在脚本结束时将数组...

问在循环中迭代时，在循环中访问MySQL的效率是高还是低？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在循环中迭代时，在循环中访问MySQL的效率是高还是低？EN