help: speed of inserting records(10,000,000) into mysql

[zjcboy]

This is the table structure in mysql:

create table test(
a1 char,
a2 char,
a3 char,
a4 char,
a5 char,
a6 char,
a7 char,

id unsigned int primary auto_increment);

This is the php code to insert LOTS of records into the table:

for($a1=0;$a1<=9;$a++){
for($a2=0;$a2<=9;$a++){
for($a3=0;$a3<=9;$a++){
for($a4=0;$a4<=9;$a++){
for($a5=0;$a5<=9;$a++){
for($a6=0;$a6<=9;$a++){
for($a7=0;$a7<=9;$a++){
mysql_query("insert into test set a1=$a1,a2=$a2,a3=$a3,a4=$a4,a5=$a5,a6=$a6,a7=$a7" )
}
}
}
}
}
}
}

---

this code would take a very long time to finish inserting records and IIS gives a CGI Timeout Error. I'd like to know how I could solve this problem. I'll be thankful for your reply.

[shadypalm88]

First, in PHP, put:
set_time_limit (0);
This will keep PHP from timing out. However, you have said that you are using IIS. IIS will time out on its own. To avoid this, run your script from the command-line.

( \php\php.exe \path\to\myscript.php ).

-shadypalm88

[zjcboy]

It works on well!

[sdjensen]

Shouldn't the lines be changed to :

for($a1=0;$a1<=9;$a1++){ 
for($a2=0;$a2<=9;$a2++){ 
for($a3=0;$a3<=9;$a3++){ 
for($a4=0;$a4<=9;$a4++){ 
for($a5=0;$a5<=9;$a5++){ 
for($a6=0;$a6<=9;$a6++){ 
for($a7=0;$a7<=9;$a7++){ 

otherwise the loops will run forever.

[zjcboy]

Originally posted by sdjensen
Shouldn't the lines be changed to :

for($a1=0;$a1<=9;$a1++){ 
for($a2=0;$a2<=9;$a2++){ 
for($a3=0;$a3<=9;$a3++){ 
for($a4=0;$a4<=9;$a4++){ 
for($a5=0;$a5<=9;$a5++){ 
for($a6=0;$a6<=9;$a6++){ 
for($a7=0;$a7<=9;$a7++){ 

otherwise the loops will run forever. [/B]

Oh, yeah, I just made a mistake 🙂