On Saturday 16 August 2003 4:41, Hans van Harten wrote: > Depending on your exact needs, consider brutal overwrites: > LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE > > Replaces 10000 rows within 3.5 s into Innodb running MySQL-max-4.10 and > WinXP on Celeron /400MHz/ for me.
Is there a need for CONCURRENT when using InnoDB? Isn't that the default for InnoDB? If not, does it lock the entire InnoDB table while the insert is running? -Jackson > > HansH -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]