How to speed up the execution of INSERT statement in MySQL? 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

WebSiteAdmin.biz

How to speed up the execution of INSERT statement in MySQL?

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

A very good approach to speed up the execution of an INSERT statement
is to temporarly disable the keys (when executing your query), this
will help MySQL to concetrate on the INSERT and not building indexes at the same
time.

The basic syntaxt of such a sample operation is listed below:

ALTER TABLE table_name DISABLE KEYS;

LOAD DATA INFILE file_name INTO TABLE table_name

ALTER TABLE table_name ENABLE KEYS;

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