Click here to Skip to main content
15,886,110 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have 50000 records.. How to insert all records to ProductInfo table..

Now i am using below query.But it take more time to insert all records..

insert into ProductInfo(ProId,BatchId,Qty,Size,Hour,Duration) values (12,0,1423,470,5,0);

Please Help me..
Posted

1 solution

Before you do an insert, you can disable triggers and drop foreign keys.
This might help improve performance slightly.
 
Share this answer
 
Comments
Kornfeld Eliyahu Peter 12-Feb-15 2:48am    
An maybe let insert invalid data too...
And 50,000 records are not even large, not to say huge!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900