Is the LOAD DATA statement faster than INSERT and how much? free example, tutorial, source code

home page latest news web development curriculum vitae scripts contact me

• C# (Microsoft .NET)
• JAVA
• Dynamic HTML
• PHP & MySQL
• ASP.NET - C# & VB.NET
• Perl & CGI
• C | C++
• Vector Markup Language
• SMIL
• Assembler
• Databases
• Wap Development
• Web site promotion
• Web Marketing

Is the LOAD DATA statement faster than INSERT and how much?

(Free programming example written by Anton Zamov.
Find more free examples on "The ultimate source for developers" )

The LOAD DATA statement could be 15 even 20 faster than an ordinary INSERT
so you should consider to use it when intending to insert a lot of data

The basic syntax of the LOAD DATA statement is shown below:

LOAD DATA INFILE file_name INTO TABLE table_name

Jobs Portal, poweful jobs board software

PHP Mall, multi vendors mall website software

Car Portal, php script for auto classifieds websites

NetArt Media, software products and services

Real Estate Portal, web software for real estate portals

Blog System, multi user blog hosting script

PHP Store, powerful e-commerce system written in PHP