lots of time taking when inserting 1000 records

[kokul_k]

Hi..
I'm facing a problem during inserting records in Mysql database. My
table consists of 9 fields. When i try to insert 1000 records to this
table using for loop it takes a lot of time.. nearly 5 mins. How can i
reduce this time?? Can u plz help me to reduce this insertion time...

Thanks in advance
Kokul
--
kokul_k
------------------------------------------------------------------------
kokul_k's Profile: http://www.dbtalk.net/m572
View this thread: http://www.dbtalk.net/t321618

[Aggro]

kokul_k wrote:

Hi..
I'm facing a problem during inserting records in Mysql database. My
table consists of 9 fields. When i try to insert 1000 records to this
table using for loop it takes a lot of time.. nearly 5 mins. How can i
reduce this time?? Can u plz help me to reduce this insertion time...

Insert multiple items with single query:
insert into tablename(id,name) values(1,'Jack'),(2,'Jill'),(3,'Bob');

[andrea azzini]

kokul_k ha scritto:

I'm facing a problem during inserting records in Mysql database. My
table consists of 9 fields. When i try to insert 1000 records to this
table using for loop it takes a lot of time.. nearly 5 mins. How can i
reduce this time?? Can u plz help me to reduce this insertion time...

You can read this page from mysql.org http://tinyurl.com/bjyl9 that
have some methods for optimizing the performance of insert statement.