Re: Speeding up series of complex INSERTS

Rudy Lippan <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]> 
On Fri, 13 May 2005, KEVIN ZEMBOWER wrote:

> Would INSERT DELAYED help here? Would it be worthwhile to rewrite my program
> completely to generate a series of input files that I could use LOAD DATA
> INFILE with? I'm guessing that the most probable speed-up might occur if I
> disable the indexes, load the data, then recreate the indexes with myisamchk

This is going probably going to give you the best performance.  And 
don't forget run optimize table beteen loads. 

Rudy


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.