怎么提高执行效率

如何提高执行效率

<br />for($i=0; $i<count($r); $i++)<br />	{<br />		$var = explode(" ,",$r[$i]);<br />		$barcode = $var[0];<br />		$num = $var[1];<br />		$sql = "insert into `".$t."`(barcode,num) values('".$barcode."','".$num."')";<br />		echo $sql.'<br />';<br />		mysql_query($sql);<br />	}<br />

一共有6000多条记录，如果每条记录都执行insert into，消耗时间很长，超过默认的90s。有无方法提高执行效率？

分享到：

------解决方案--------------------
可以把要插入数组先写入到数组，最后统一插入

<br /><br />for($i=0; $i<count($r); $i++)<br />	{<br />		$var = explode(" ,",$r[$i]);<br />		$barcode = $var[0];<br />		$num = $var[1];<br />		$sql[] = "('".$barcode."','".$num."')";//写入到sql数组<br />	}<br />mysql_query('insert into `'.$t.'`(barcode,num)  values '.implode(',',$sql));<br />//统一插入<br />

------解决方案--------------------

引用:

报错信息：
Maximum execution time of 90 seconds exceeded

时间超时可以在头上面加上
set_time_limit(0);
?>

Related labels：

nbsp sql var

source：php.cn

Previous article：一个mysql查询的有关问题,马上就能结贴 Next article：phpexcel的有关问题，怎么写入已存在的excel

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Latest Articles by Author

• What is a NullPointerException, and how do I fix it?
  2024-10-22 09:46:29
• From Novice to Coder: Your Journey Begins with C Fundamentals
  2024-10-13 13:53:41
• Unlocking Web Development with PHP: A Beginner's Guide
  2024-10-12 12:15:51
• Demystifying C: A Clear and Simple Path for New Programmers
  2024-10-11 22:47:31
• Unlock Your Coding Potential: C Programming for Absolute Beginners
  2024-10-11 19:36:51
• Unleash Your Inner Programmer: C for Absolute Beginners
  2024-10-11 15:50:41
• Automate Your Life with C: Scripts and Tools for Beginners
  2024-10-11 15:07:41
• PHP Made Easy: Your First Steps in Web Development
  2024-10-11 14:21:21
• Build Anything with Python: A Beginner's Guide to Unleashing Your Creativity
  2024-10-11 12:59:11
• The Key to Coding: Unlocking the Power of Python for Beginners
  2024-10-11 12:17:31

Latest Issues

function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...

From 2024-04-29 11:01:01

0

2

1429

There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...

From 2024-04-18 23:52:34

0

1

1284

PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...

From 2024-04-16 09:34:16

0

0

4687

Related Topics

More>

• What are the data analysis tools?
• Usage of distinct in SQL
• How to use months_between in SQL
• SQL 5120 error solution
• Solution to sql procedure syntax error
• oracle database running sql method
• The meaning of where in sql
• What is the statement to delete a table in sql

Popular Recommendations

• How to set up hosts on Mac computer (steps with pictures and text)
• Quickly build a simple QQ robot with PHP
• API common signature verification methods (PHP implementation)
• Collection of common date and time operations in PHP
• PHP generates graphic verification code (enhanced interference type)

Popular Tutorials

More>

Related Tutorials

Popular Recommendations

Latest courses

• 
  The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)

  1424329
• 
  PHP introductory tutorial one: Learn PHP in one week

  4270615
• 
  JAVA Beginner's Video Tutorial

  2548291
• 
  Little Turtle's zero-based introduction to learning Python video tutorial

  507955
• 
  PHP zero-based introductory tutorial

  863649

• 
  The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)

  1424329 times of learning
• 
  JAVA Beginner's Video Tutorial

  2548291 times of learning
• 
  Little Turtle's zero-based introduction to learning Python video tutorial

  507955 times of learning
• 
  Quick introduction to web front-end development

  215953 times of learning
• 
  Master PS video tutorials from scratch

  892357 times of learning

• 
  [Web front-end] Node.js quick start

  7660 times of learning
• 
  Complete collection of foreign web development full-stack courses

  6129 times of learning
• 
  Go language practical GraphQL

  5065 times of learning
• 
  550W fan master learns JavaScript from scratch step by step

  706 times of learning
• 
  Python master Mosh, a beginner with zero basic knowledge can get started in 6 hours

  25737 times of learning

Latest Downloads

More>

Web Effects

Website Source Code

Website Materials

Front End Template

• [form button] jQuery enterprise message form contact code
• [Player special effects] HTML5 MP3 music box playback effects
• [Menu navigation] HTML5 cool particle animation navigation menu special effects
• [form button] jQuery visual form drag and drop editing code
• [Player special effects] VUE.JS imitation Kugou music player code
• [html5 special effects] Classic html5 pushing box game
• [Picture special effects] jQuery scrolling to add or reduce image effects
• [Photo album effects] CSS3 personal album cover hover zoom effect

• [Front-end template] Home Decor Cleaning and Repair Service Company Website Template
• [Front-end template] Fresh color personal resume guide page template
• [Front-end template] Designer Creative Job Resume Web Template
• [Front-end template] Modern engineering construction company website template
• [Front-end template] Responsive HTML5 template for educational service institutions
• [Front-end template] Online e-book store mall website template
• [Front-end template] IT technology solves Internet company website template
• [Front-end template] Purple style foreign exchange trading service website template

• [PNG material] Cute summer elements vector material (EPS PNG)
• [PNG material] Four red 2023 graduation badges vector material (AI EPS PNG)
• [banner picture] Singing bird and cart filled with flowers design spring banner vector material (AI EPS)
• [PNG material] Golden graduation cap vector material (EPS PNG)
• [PNG material] Black and white style mountain icon vector material (EPS PNG)
• [PNG material] Superhero silhouette vector material (EPS PNG) with different color cloaks and different poses
• [banner picture] Flat style Arbor Day banner vector material (AI+EPS)
• [PNG material] Nine comic-style exploding chat bubbles vector material (EPS+PNG)

• [Front-end template] Home Decor Cleaning and Repair Service Company Website Template
• [Front-end template] Fresh color personal resume guide page template
• [Front-end template] Designer Creative Job Resume Web Template
• [Front-end template] Modern engineering construction company website template
• [Front-end template] Responsive HTML5 template for educational service institutions
• [Front-end template] Online e-book store mall website template
• [Front-end template] IT technology solves Internet company website template
• [Front-end template] Purple style foreign exchange trading service website template