I have a code below:
for (int i = 0; i < 100000; i++)
sql += "Begin tran t1 insert into LUONGKHOAN(MaLuongKhoan) values("+i +") commit tran t1 ";
When I finished, all 45s.How to faster processing.Thanks for sharing community.
Your code is not complete , so I don't know this - however, I think you might be making a call to insert to the database one by one.
Try to send the request just once - this will save a lot of time going back and forth over the network to insert data/
No no. I just do it, not to add to the database.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)