;line too long".
Cheers
/rudy
-Original Message-
From: Phil Bitis [mailto:[EMAIL PROTECTED]
Sent: maandag 14 juli 2003 11:44
To: [EMAIL PROTECTED]
Subject: Re: Improving insertion performance by locking tables
Is there a limit to the number of records I can insert in a
multiple-value
insert?
Is there a limit to the number of records I can insert in a multiple-value
insert?
- Original Message -
From: "Rudy Metzger" <[EMAIL PROTECTED]>
To: "Phil Bitis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 10:18 AM
Subject:
>From what I know is, that MySQL always locks the MyISAM table before you
insert, update or delete something from it. So the key here is not so
much if you should lock the table, but how you insert the data (single
inserts vs multi inserts). Multi inserts are the way to go. By locking
the table you