The LOAD DATA statement reads rows from a text file into a table at a very high speed. The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. LOCAL also affects data interpretation and error handling.
Lets Run a Quick Test !
Loading Data Into a Table in the local Database using MySQL workbench Executed around 35Min (2098.781 Sec) for 35K records.
Now Lets Truncate the Table and re-load the data using LOAD DATA Statement
Hi there, This is SCP Ranga Rao Sanka working as (A product Manager/Principal DBA)., I have a broad range of Experience in Administration and Implementation in the areas of Database, Cloud, and Other Servers. I am one of the moderators at ORAFAQ. The primary purpose of this blog is to share knowledge.
All the code snippets, URLs, and everything in this blog are from My experience, My Learnings from different websites & forums. so please test the posts on your testing Environment first.
The experiences, Test cases, views, and opinions, etc., expressed on this website are my own and do not reflect the views or opinions of my employer.
This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content. Product and company names mentioned on this website may be the trademarks of their respective owners. I am not responsible for any kind of Damage or any legal activities.
Sriram Sanka 
Leave a comment