lots of time taking when inserting 1000 records

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

Re: lots of time taking when inserting 1000 records

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');

Re: lots of time taking when inserting 1000 records

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.